explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d9Oj : it-3358-split

Settings
# exclusive inclusive rows x rows loops node
1. 7,321.427 7,321.427 ↓ 1,002.0 1,002 1

Unique (cost=1,533.980..1,533.980 rows=1 width=128) (actual time=7,321.079..7,321.427 rows=1,002 loops=1)

2.          

CTE romeo_charlie

3. 1,107.613 7,310.065 ↓ 3,004.0 3,004 1

Merge Join (cost=1,506.290..1,525.720 rows=1 width=163) (actual time=6,212.917..7,310.065 rows=3,004 loops=1)

  • Merge Cond: (november_lima.bravo_tango = golf_juliet15.quebec_seven_victor)
4. 6,202.452 6,202.452 ↓ 751.0 3,004 1

Sort (cost=386.730..386.740 rows=4 width=100) (actual time=6,201.730..6,202.452 rows=3,004 loops=1)

  • Sort Key: november_lima.bravo_tango, november_lima.bravo_six, november_lima.golf_november DESC
  • Sort Method: quicksort Memory: 519kB
5.          

CTE yankee_foxtrot

6. 0.167 1.630 ↓ 1,002.0 1,002 1

Subquery Scan on zulu_four (cost=263.950..264.450 rows=1 width=12) (actual time=0.148..1.630 rows=1,002 loops=1)

  • Filter: (golf_juliet10.xray_two = 17)
  • Rows Removed by Filter: 2
7. 1.463 1.463 ↓ 91.3 1,004 1

Append (cost=263.950..264.310 rows=11 width=44) (actual time=0.147..1.463 rows=1,004 loops=1)

8.          

CTE oscar_kilo_quebec

9. 0.003 0.298 ↓ 2.0 2 1

Nested Loop (cost=188.870..218.520 rows=1 width=44) (actual time=0.146..0.298 rows=2 loops=1)

  • Join Filter: ((romeo_hotel11.quebec_seven_victor)::text = (golf_juliet8.kilo_sierra_hotel)::text)
10. 0.175 0.175 ↑ 1.0 1 1

Seq Scan on zulu_zulu golf_zulu (cost=0.000..29.540 rows=1 width=7) (actual time=0.026..0.175 rows=1 loops=1)

  • Filter: ((five_echo)::text = 'zulu_hotel'::text)
  • Rows Removed by Filter: 1002
11. 0.002 0.120 ↑ 2.0 2 1

Unique (cost=188.870..188.900 rows=4 width=108) (actual time=0.118..0.120 rows=2 loops=1)

12.          

CTE quebec_seven_oscar

13. 0.005 0.016 ↑ 1.0 2 1

Bitmap Heap Scan on four seven (cost=4.160..9.500 rows=2 width=40) (actual time=0.015..0.016 rows=2 loops=1)

  • Recheck Cond: (mike_three @> LOCALTIMESTAMP)
  • Heap Blocks: exact=1
14. 0.011 0.011 ↓ 9.0 18 1

Bitmap Index Scan on november_alpha (cost=0.000..4.160 rows=2 width=0) (actual time=0.011..0.011 rows=18 loops=1)

  • Index Cond: (mike_three @> LOCALTIMESTAMP)
15.          

CTE delta_romeo

16. 0.001 0.089 ↑ 447.0 2 1

Append (cost=2.460..115.810 rows=894 width=108) (actual time=0.079..0.089 rows=2 loops=1)

17. 0.002 0.086 ↑ 7.0 2 1

Result (cost=2.460..46.040 rows=14 width=108) (actual time=0.079..0.086 rows=2 loops=1)

18. 0.000 0.084 ↑ 7.0 2 1

Append (cost=2.460..45.860 rows=14 width=104) (actual time=0.078..0.084 rows=2 loops=1)

19. 0.000 0.031 ↓ 0.0 0 1

Nested Loop (cost=2.460..25.090 rows=10 width=60) (actual time=0.031..0.031 rows=0 loops=1)

20. 0.004 0.031 ↓ 0.0 0 1

Nested Loop (cost=2.190..21.460 rows=10 width=36) (actual time=0.031..0.031 rows=0 loops=1)

21. 0.019 0.019 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar oscar_kilo_bravo (cost=0.000..0.040 rows=2 width=8) (actual time=0.017..0.019 rows=2 loops=1)

22. 0.002 0.008 ↓ 0.0 0 2

Bitmap Heap Scan on victor zulu_bravo (cost=2.190..10.660 rows=5 width=36) (actual time=0.004..0.004 rows=0 loops=2)

  • Recheck Cond: (mike_uniform = delta_juliet4.quebec_seven_victor)
23. 0.006 0.006 ↓ 0.0 0 2

Bitmap Index Scan on charlie (cost=0.000..2.190 rows=5 width=0) (actual time=0.003..0.003 rows=0 loops=2)

  • Index Cond: (mike_uniform = delta_juliet4.quebec_seven_victor)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using delta_lima on yankee_echo zulu_foxtrot (cost=0.280..0.360 rows=1 width=20) (never executed)

  • Index Cond: ((quebec_seven_victor)::text = (india_golf2.kilo_sierra_alpha)::text)
25. 0.003 0.053 ↑ 2.0 2 1

Nested Loop (cost=0.340..20.630 rows=4 width=60) (actual time=0.046..0.053 rows=2 loops=1)

26. 0.007 0.016 ↑ 2.0 2 1

Hash Join (cost=0.070..18.650 rows=4 width=36) (actual time=0.014..0.016 rows=2 loops=1)

  • Hash Cond: ((sierra_juliet2.echo)::text = (delta_juliet5.echo)::text)
27. 0.005 0.005 ↑ 360.0 1 1

Seq Scan on india_six whiskey (cost=0.000..17.200 rows=360 width=64) (actual time=0.004..0.005 rows=1 loops=1)

  • Filter: "default
28. 0.002 0.004 ↑ 1.0 2 1

Hash (cost=0.040..0.040 rows=2 width=36) (actual time=0.004..0.004 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.002 0.002 ↑ 1.0 2 1

CTE Scan on quebec_seven_oscar two (cost=0.000..0.040 rows=2 width=36) (actual time=0.001..0.002 rows=2 loops=1)

30. 0.034 0.034 ↑ 1.0 1 2

Index Scan using delta_lima on yankee_echo xray_tango (cost=0.280..0.490 rows=1 width=20) (actual time=0.017..0.017 rows=1 loops=2)

  • Index Cond: ((quebec_seven_victor)::text = (sierra_juliet2.kilo_sierra_alpha)::text)
31. 0.000 0.002 ↓ 0.0 0 1

Hash Join (cost=31.070..60.970 rows=880 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: ((three2.kilo_sierra_alpha)::text = (romeo_hotel10.quebec_seven_victor)::text)
32. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on papa five_bravo (cost=0.000..18.800 rows=880 width=40) (actual time=0.002..0.002 rows=0 loops=1)

33. 0.000 0.000 ↓ 0.0 0

Hash (cost=18.810..18.810 rows=981 width=20) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Seq Scan on yankee_echo romeo_yankee (cost=0.000..18.810 rows=981 width=20) (never executed)

35. 0.008 0.118 ↑ 2.0 2 1

Sort (cost=63.550..63.560 rows=4 width=108) (actual time=0.118..0.118 rows=2 loops=1)

  • Sort Key: romeo_hotel11.quebec_seven_victor, romeo_hotel11.xray_two, romeo_hotel11.sierra_three
  • Sort Method: quicksort Memory: 25kB
36. 0.110 0.110 ↑ 2.0 2 1

Hash Left Join (cost=32.000..63.510 rows=4 width=108) (actual time=0.098..0.110 rows=2 loops=1)

  • Hash Cond: (((romeo_hotel11.quebec_seven_victor)::text = (bravo_quebec2.kilo_sierra_alpha)::text) AND (romeo_hotel11.xray_two = bravo_quebec2.xray_two))
  • Filter: (bravo_quebec2.* five_romeo NULL)