explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nB4Z

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.377 50.896 ↓ 1.4 159 1

Sort (cost=332.39..332.68 rows=115 width=258) (actual time=50.866..50.896 rows=159 loops=1)

  • Sort Key: core_application.id
  • Sort Method: quicksort Memory: 206kB
2. 43.900 50.519 ↓ 1.4 159 1

Nested Loop Left Join (cost=2.15..328.46 rows=115 width=258) (actual time=0.791..50.519 rows=159 loops=1)

3. 0.169 5.506 ↓ 1.4 159 1

Nested Loop Left Join (cost=1.58..223.52 rows=115 width=79) (actual time=0.054..5.506 rows=159 loops=1)

4. 0.045 3.111 ↓ 1.4 159 1

Nested Loop (cost=1.01..140.83 rows=115 width=75) (actual time=0.031..3.111 rows=159 loops=1)

5. 0.136 1.317 ↓ 1.6 159 1

Nested Loop (cost=0.43..77.76 rows=100 width=64) (actual time=0.016..1.317 rows=159 loops=1)

6. 0.068 0.068 ↓ 1.6 159 1

Result (cost=0.00..0.51 rows=100 width=4) (actual time=0.006..0.068 rows=159 loops=1)

7. 1.113 1.113 ↑ 1.0 1 159

Index Scan using core_application_pkey on core_application (cost=0.43..0.75 rows=1 width=60) (actual time=0.006..0.007 rows=1 loops=159)

  • Index Cond: (id = (unnest('{1,2,4,10,16,303,591,616,1073,1329,1649,1823,2130,2309,2421,2832,3812,4061,4073,4258,4432,5137,5141,5150,5152,5167,5280,7526,8915,8920,9242,9255,11864,13660,15216,15311,15312,15313,15314,15780,17885,17886,19469,19920,21022,21031,22782,24351,25724,28514,28680,29270,29400,34937,36170,38755,40465,42752,44896,45530,46656,49444,49933,50998,53224,54220,60081,60631,62233,63008,63069,80945,82762,88354,91504,91619,95142,96644,96646,98004,102166,105775,114097,114371,129505,145292,153429,162807,177025,177331,180238,180304,200036,216474,318850,343073,518626,537390,576810,585428,632577,646250,1301839,1313085,1770554,1999731,2195290,2322912,2357355,2357623,3037620,3277533,3563903,3687682,3807229,3876656,4589847,4763264,5338985,5636989,6034485,6245921,6249256,6314001,6427459,6647171,6775570,6817394,7032674,7192960,7254125,7359751,7429636,7448063,7477924,7516710,7721596,7758128,7786275,7787887,7849296,7946442,8160127,8203043,8221501,8225607,8242664,8441435,8840847,9153578,9217877,9395508,9510991,9614731,9670655,10093094,10200664,10433337,10465286}'::integer[])))
8. 1.749 1.749 ↑ 1.0 1 159

Index Scan using core_applicationlocale_app_id_6e079ea4b80d3ad6_uniq on core_applicationlocale (cost=0.57..0.62 rows=1 width=15) (actual time=0.010..0.011 rows=1 loops=159)

  • Index Cond: ((app_id = core_application.id) AND ((country)::text = 'CA'::text))
9. 0.000 2.226 ↑ 1.0 1 159

Limit (cost=0.57..0.70 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=159)

10. 2.226 2.226 ↑ 138.0 1 159

Index Scan using core_appslice_applocale_timestamp_idx on core_appslice (cost=0.57..18.04 rows=138 width=32) (actual time=0.014..0.014 rows=1 loops=159)

  • Index Cond: (core_applicationlocale.id = applocale_id)
11. 1.113 1.113 ↑ 1.0 1 159

Index Scan using core_appmeta_isfull_idx on core_appmeta (cost=0.57..0.89 rows=1 width=293) (actual time=0.007..0.007 rows=1 loops=159)

  • Index Cond: (core_appslice.meta_id = id)
Planning time : 1.788 ms
Execution time : 51.089 ms