explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3aLi

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 32.747 ↓ 0.0 0 1

Insert on alpha (cost=322.870..323.140 rows=12 width=67) (actual time=32.747..32.747 rows=0 loops=1)

2. 0.008 32.726 ↑ 6.0 2 1

HashAggregate (cost=322.870..323.020 rows=12 width=67) (actual time=32.725..32.726 rows=2 loops=1)

3. 0.002 32.718 ↑ 3.0 4 1

Append (cost=161.250..322.750 rows=12 width=67) (actual time=19.294..32.718 rows=4 loops=1)

4. 0.043 19.293 ↑ 3.0 2 1

HashAggregate (cost=161.250..161.310 rows=6 width=41) (actual time=19.293..19.293 rows=2 loops=1)

5. 0.110 19.250 ↓ 3.3 20 1

Nested Loop (cost=11.360..161.190 rows=6 width=41) (actual time=10.818..19.250 rows=20 loops=1)

6. 0.119 0.754 ↓ 29.0 58 1

Hash Semi Join (cost=11.360..20.010 rows=2 width=23) (actual time=0.607..0.754 rows=58 loops=1)

  • Hash Cond: ((quebec.whiskey)::text = ("zulu_juliet".bravo_quebec)::text)
7. 0.053 0.053 ↑ 1.0 366 1

Seq Scan on golf_lima quebec (cost=0.000..7.660 rows=366 width=23) (actual time=0.010..0.053 rows=366 loops=1)

8. 0.017 0.582 ↓ 38.0 38 1

Hash (cost=11.350..11.350 rows=1 width=9) (actual time=0.582..0.582 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
9. 0.007 0.565 ↓ 38.0 38 1

Subquery Scan on four (cost=11.330..11.350 rows=1 width=9) (actual time=0.538..0.565 rows=38 loops=1)

10. 0.020 0.558 ↓ 38.0 38 1

Group (cost=11.330..11.340 rows=1 width=23) (actual time=0.536..0.558 rows=38 loops=1)

11. 0.285 0.538 ↓ 38.0 38 1

Sort (cost=11.330..11.340 rows=1 width=23) (actual time=0.533..0.538 rows=38 loops=1)

  • Sort Key: charlie_victor.golf_lima.oscar_golf, charlie_victor.golf_lima.whiskey
  • Sort Method: quicksort Memory: 19kB
12. 0.253 0.253 ↓ 38.0 38 1

Seq Scan on golf_lima (cost=0.000..11.320 rows=1 width=23) (actual time=0.023..0.253 rows=38 loops=1)

  • Filter: (("zulu_quebec"((oscar_golf)::text, 4, 1) = ANY ('kilo'::text[])) AND ("zulu_quebec"((oscar_golf)::text, 1, 3) = 'five'::text))
13. 18.386 18.386 ↓ 0.0 0 58

Index Scan using victor on charlie_yankee november (cost=0.000..70.500 rows=7 width=32) (actual time=0.310..0.317 rows=0 loops=58)

  • Index Cond: (((oscar_four)::text = 'golf_seven'::text) AND (papa_zulu >= 'papa_alpha'::timestamp without time zone) AND (papa_zulu <= 'foxtrot'::timestamp without time zone) AND ((xray (...)
  • Filter: ((yankee)::text <> (bravo_india)::text)
14. 0.012 13.423 ↑ 3.0 2 1

HashAggregate (cost=161.250..161.320 rows=6 width=41) (actual time=13.422..13.423 rows=2 loops=1)

15. 0.027 13.411 ↑ 1.2 5 1

Nested Loop (cost=11.360..161.190 rows=6 width=41) (actual time=5.313..13.411 rows=5 loops=1)

16. 0.078 0.392 ↓ 29.0 58 1

Hash Semi Join (cost=11.360..20.010 rows=2 width=23) (actual time=0.301..0.392 rows=58 loops=1)

  • Hash Cond: ((quebec.whiskey)::text = ("zulu_juliet".bravo_quebec)::text)
17. 0.032 0.032 ↑ 1.0 366 1

Seq Scan on golf_lima quebec (cost=0.000..7.660 rows=366 width=23) (actual time=0.003..0.032 rows=366 loops=1)

18. 0.008 0.282 ↓ 38.0 38 1

Hash (cost=11.350..11.350 rows=1 width=9) (actual time=0.282..0.282 rows=38 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
19. 0.004 0.274 ↓ 38.0 38 1

Subquery Scan on four (cost=11.330..11.350 rows=1 width=9) (actual time=0.261..0.274 rows=38 loops=1)

20. 0.009 0.270 ↓ 38.0 38 1

Group (cost=11.330..11.340 rows=1 width=23) (actual time=0.260..0.270 rows=38 loops=1)

21. 0.137 0.261 ↓ 38.0 38 1

Sort (cost=11.330..11.340 rows=1 width=23) (actual time=0.259..0.261 rows=38 loops=1)

  • Sort Key: charlie_victor.golf_lima.oscar_golf, charlie_victor.golf_lima.whiskey
  • Sort Method: quicksort Memory: 19kB
22. 0.124 0.124 ↓ 38.0 38 1

Seq Scan on golf_lima (cost=0.000..11.320 rows=1 width=23) (actual time=0.013..0.124 rows=38 loops=1)

  • Filter: (("zulu_quebec"((oscar_golf)::text, 4, 1) = ANY ('kilo'::text[])) AND ("zulu_quebec"((oscar_golf)::text, 1, 3) = 'five'::text))
23. 12.992 12.992 ↓ 0.0 0 58

Index Scan using zulu_hotel on charlie_yankee november (cost=0.000..70.500 rows=7 width=32) (actual time=0.219..0.224 rows=0 loops=58)

  • Index Cond: (((oscar_four)::text = 'golf_seven'::text) AND (papa_zulu >= 'papa_alpha'::timestamp without time zone) AND (papa_zulu <= 'foxtrot'::timestamp without time zone) AND ((xray (...)
  • Filter: ((yankee)::text <> (bravo_india)::text)