Skip to content

Instantly share code, notes, and snippets.

@dbrgn

dbrgn/1_before.py

Last active August 29, 2015 14:00
Show Gist options
  • Save dbrgn/427f5330cc08da1c3a4c to your computer and use it in GitHub Desktop.
Save dbrgn/427f5330cc08da1c3a4c to your computer and use it in GitHub Desktop.
Download ZIP
before / after prefetch
Raw
1_before.py
In [1]: from apps.swid.models import Tag
In [2]: s = Session.objects.latest()
QUERY = u'SELECT "sessions"."id", "sessions"."time", "sessions"."connection", "sessions"."identity", "sessions"."device", "sessions"."rec" FROM "sessions" ORDER BY "sessions"."time" DESC LIMIT 1' - PARAMS = ()
Execution time: 0.004259s [Database: default]
In [3]: tags = Tag.get_installed_tags_with_time(s)
QUERY = u'SELECT "devices"."id", "devices"."value", "devices"."description", "devices"."product", "devices"."created", "devices"."trusted" FROM "devices" WHERE "devices"."id" = %s ' - PARAMS = (20,)
Execution time: 0.000312s [Database: default]
QUERY = u'SELECT "sessions"."id", "sessions"."time", "sessions"."connection", "sessions"."identity", "sessions"."device", "sessions"."rec" FROM "sessions" WHERE ("sessions"."device" = %s AND "sessions"."time" <= %s ) ORDER BY "sessions"."time" ASC' - PARAMS = (20,
1393236615)
Execution time: 0.000414s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (497,)
Execution time: 0.000237s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (646,)
Execution time: 0.000105s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (647,)
Execution time: 0.000104s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (648,)
Execution time: 0.000097s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (649,)
Execution time: 0.000095s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (659,)
Execution time: 0.000095s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (676,)
Execution time: 0.000088s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (677,)
Execution time: 0.000090s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (678,)
Execution time: 0.000089s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (709,)
Execution time: 0.000089s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (710,)
Execution time: 0.000116s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (711,)
Execution time: 0.000117s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (712,)
Execution time: 0.000084s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (713,)
Execution time: 0.000084s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (714,)
Execution time: 0.000077s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (715,)
Execution time: 0.000056s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (716,)
Execution time: 0.000056s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (717,)
Execution time: 0.000052s [Database: default]
QUERY = u'SELECT "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" = %s ' - PARAMS = (720,)
Execution time: 0.000054s [Database: default]
Raw
2_after.py
In [1]: from apps.swid.models import Tag
In [2]: s = Session.objects.latest()
QUERY = u'SELECT "sessions"."id", "sessions"."time", "sessions"."connection", "sessions"."identity", "sessions"."device", "sessions"."rec" FROM "sessions" ORDER BY "sessions"."time" DESC LIMIT 1' - PARAMS = ()
Execution time: 0.001875s [Database: default]
In [3]: tags = Tag.get_installed_tags_with_time(s)
QUERY = u'SELECT "devices"."id", "devices"."value", "devices"."description", "devices"."product", "devices"."created", "devices"."trusted" FROM "devices" WHERE "devices"."id" = %s ' - PARAMS = (20,)
Execution time: 0.000421s [Database: default]
QUERY = u'SELECT "sessions"."id", "sessions"."time", "sessions"."connection", "sessions"."identity", "sessions"."device", "sessions"."rec" FROM "sessions" WHERE ("sessions"."device" = %s AND "sessions"."time" <= %s ) ORDER BY "sessions"."time" ASC' - PARAMS = (20,
1393236615)
Execution time: 0.000742s [Database: default]
QUERY = u'SELECT ("swid_tags_sessions"."session_id") AS "_prefetch_related_val_session_id", "swid_tags"."id", "swid_tags"."package_name", "swid_tags"."version", "swid_tags"."unique_id", "swid_tags"."swid_xml" FROM "swid_tags" INNER JOIN "swid_tags_sessions" ON ( "swid_tags"."id" = "swid_tags_sessions"."tag_id" ) WHERE "swid_tags_sessions"."session_id" IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' - PARAMS = (497,
646,
647,
648,
649,
659,
676,
677,
678,
709,
710,
711,
712,
713,
714,
715,
716,
717,
720)
Execution time: 0.000378s [Database: default]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment