explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pFdp

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.037 ↓ 0.0 0 1

Nested Loop Left Join (cost=22.650..3,133,957.130 rows=90,000 width=11,376) (actual time=0.037..0.037 rows=0 loops=1)

  • Join Filter: (whiskey_delta.november = (foxtrot.zulu_five)::text)
2. 0.000 0.036 ↓ 0.0 0 1

Nested Loop Left Join (cost=22.650..9,544.100 rows=18,000 width=12,750) (actual time=0.036..0.036 rows=0 loops=1)

  • Join Filter: (((romeo_delta.echo_india_oscar ->> 'hotel_kilo'::text))::integer = golf_foxtrot.quebec_seven)
3. 0.001 0.036 ↓ 0.0 0 1

Nested Loop Left Join (cost=22.650..5,500.540 rows=18,000 width=12,234) (actual time=0.036..0.036 rows=0 loops=1)

  • Join Filter: (romeo_delta.zulu_four = quebec_hotel.quebec_seven)
4. 0.000 0.035 ↓ 0.0 0 1

Merge Join (cost=1.060..67.740 rows=18,000 width=9,638) (actual time=0.035..0.035 rows=0 loops=1)

  • Merge Cond: (foxtrot.tango_hotel = romeo_delta.quebec_seven)
5. 0.001 0.035 ↓ 0.0 0 1

Nested Loop (cost=0.790..45.960 rows=20 width=9,022) (actual time=0.035..0.035 rows=0 loops=1)

6. 0.000 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.650..37.040 rows=1 width=7,890) (actual time=0.034..0.034 rows=0 loops=1)

  • Join Filter: (foxtrot.five_zulu = lima_november.quebec_seven)
7. 0.000 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.530..28.890 rows=1 width=7,374) (actual time=0.034..0.034 rows=0 loops=1)

  • Join Filter: (foxtrot.romeo_xray = mike.quebec_seven)
8. 0.000 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.400..20.740 rows=1 width=6,314) (actual time=0.034..0.034 rows=0 loops=1)

9. 0.034 0.034 ↓ 0.0 0 1

Index Scan using tango_whiskey on foxtrot (cost=0.120..9.060 rows=1 width=5,186) (actual time=0.034..0.034 rows=0 loops=1)

  • Filter: ((NOT kilo_six) AND ((hotel_four)::text = 'golf_uniform'::text) AND (oscar = ANY ('six'::integer[])))
10. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.280..11.670 rows=1 width=1,132) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using echo_india_six on sierra (cost=0.140..8.150 rows=1 width=620) (never executed)

  • Index Cond: (foxtrot.oscar = quebec_seven)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using three_whiskey on whiskey_uniform (cost=0.140..3.360 rows=1 width=520) (never executed)

  • Index Cond: (quebec_seven = sierra.charlie)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using three_kilo on mike (cost=0.120..8.140 rows=1 width=1,068) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_six on lima_november (cost=0.120..8.140 rows=1 width=520) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_golf on alpha (cost=0.140..8.150 rows=1 width=1,136) (never executed)

  • Index Cond: (lima_xray = foxtrot.quebec_seven)
16. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.280..18.580 rows=900 width=616) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.280..16.330 rows=900 width=616) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using papa on romeo_delta (cost=0.120..8.140 rows=1 width=600) (never executed)

  • Filter: (tango_xray AND (victor >= 1546300800) AND (victor <= 1567727999))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using bravo on yankee (cost=0.150..8.170 rows=1 width=20) (never executed)

  • Index Cond: (tango_hotel = romeo_delta.quebec_seven)
20. 0.000 0.000 ↓ 0.0 0

Materialize (cost=21.590..32.850 rows=20 width=2,604) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=21.590..32.750 rows=20 width=2,604) (never executed)

  • Hash Cond: (kilo_five_seven.quebec_seven = quebec_hotel.whiskey_oscar)
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on kilo_five_seven (cost=0.000..10.700 rows=70 width=524) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Hash (cost=21.340..21.340 rows=20 width=2,088) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=10.450..21.340 rows=20 width=2,088) (never executed)

  • Hash Cond: (delta.quebec_seven = quebec_hotel.kilo_five_five)
25. 0.000 0.000 ↓ 0.0 0

Seq Scan on delta (cost=0.000..10.500 rows=50 width=1,552) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.200..10.200 rows=20 width=544) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on quebec_hotel (cost=0.000..10.200 rows=20 width=544) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.000..10.150 rows=10 width=520) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Seq Scan on sierra golf_foxtrot (cost=0.000..10.100 rows=10 width=520) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Function Scan on whiskey_delta (cost=0.000..10.000 rows=1,000 width=64) (never executed)

31.          

SubPlan (for Nested Loop Left Join)

32. 0.000 0.000 ↓ 0.0 0

Sort (cost=29.870..29.880 rows=4 width=36) (never executed)

  • Sort Key: seven.quebec_seven
33. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=12.840..29.830 rows=4 width=36) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=12.690..28.780 rows=4 width=72) (never executed)

  • Hash Cond: (seven.quebec_seven = four_papa.echo_hotel)
35. 0.000 0.000 ↓ 0.0 0

Seq Scan on seven (cost=0.000..14.400 rows=440 width=40) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Hash (cost=12.640..12.640 rows=4 width=36) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on four_papa (cost=4.180..12.640 rows=4 width=36) (never executed)

  • Recheck Cond: (tango_hotel = romeo_delta.quebec_seven)
38. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on four_romeo (cost=0.000..4.180 rows=4 width=0) (never executed)

  • Index Cond: (tango_hotel = romeo_delta.quebec_seven)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using india on hotel_november (cost=0.140..0.260 rows=1 width=520) (never executed)

  • Index Cond: (quebec_seven = seven.five_alpha)
Planning time : 8.710 ms
Execution time : 0.589 ms