explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6K3u

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 2,612.259 ↓ 0.0 0 1

Sort (cost=15,319.89..15,319.97 rows=34 width=219) (actual time=2,612.257..2,612.259 rows=0 loops=1)

  • Sort Key: romeo1.lima, romeo1.foxtrot_bravo DESC, romeo1.mike DESC
  • Sort Method: quicksort Memory: 25kB
2. 146.094 2,612.252 ↓ 0.0 0 1

Nested Loop (cost=1.14..15,319.02 rows=34 width=219) (actual time=2,612.251..2,612.252 rows=0 loops=1)

3. 113.560 571.322 ↓ 75.4 473,709 1

Nested Loop (cost=0.71..12,123.42 rows=6,283 width=69) (actual time=0.044..571.322 rows=473,709 loops=1)

4. 0.020 0.020 ↑ 1.0 1 1

Index Scan using uniform_echo on oscar_oscar victor_hotel (cost=0.28..2.49 rows=1 width=69) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((juliet)::text = 'golf'::text)
5. 457.742 457.742 ↓ 35.7 473,709 1

Index Scan using five_delta on uniform_kilo india (cost=0.43..11,988.20 rows=13,273 width=16) (actual time=0.023..457.742 rows=473,709 loops=1)

  • Index Cond: (four_delta = romeo4.quebec)
6. 1,894.836 1,894.836 ↓ 0.0 0 473,709

Index Scan using victor_charlie on foxtrot_romeo four_uniform (cost=0.43..0.51 rows=1 width=166) (actual time=0.004..0.004 rows=0 loops=473,709)

  • Index Cond: (quebec = romeo3.sierra)
  • Filter: (((NOT papa) OR (papa five_romeo NULL)) AND ((lima)::text = ANY ('oscar_quebec'::text[])))
  • Rows Removed by Filter: 1
Planning time : 0.622 ms
Execution time : 2,612.302 ms