explain.depesz.com

PostgreSQL's explain analyze made readable

Result: omhj

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 2,219.782 ↑ 34.0 1 1

Sort (cost=15,319.89..15,319.97 rows=34 width=219) (actual time=2,219.781..2,219.782 rows=1 loops=1)

  • Sort Key: romeo1.lima, romeo1.foxtrot_bravo DESC, romeo1.mike DESC
  • Sort Method: quicksort Memory: 25kB
2. 297.809 2,219.770 ↑ 34.0 1 1

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

3. 105.210 500.846 ↓ 75.4 473,705 1

Nested Loop (cost=0.71..12,123.42 rows=6,283 width=69) (actual time=0.043..500.846 rows=473,705 loops=1)

4. 0.021 0.021 ↑ 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.020..0.021 rows=1 loops=1)

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

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

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

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

  • 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.562 ms
Execution time : 2,219.829 ms