explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nn3p

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,084.017 ↑ 1.0 10 1

Limit (cost=79,556.480..79,556.500 rows=10 width=12) (actual time=1,084.013..1,084.017 rows=10 loops=1)

2. 28.875 1,084.013 ↑ 6.7 10 1

Sort (cost=79,556.480..79,556.640 rows=67 width=12) (actual time=1,084.011..1,084.013 rows=10 loops=1)

  • Sort Key: (((juliet_india1.six_mike ->> 'hotel'::text))::double precision) DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 72.717 1,055.138 ↓ 3,483.7 233,408 1

Nested Loop (cost=15.380..79,555.030 rows=67 width=12) (actual time=46.948..1,055.138 rows=233,408 loops=1)

  • Join Filter: (kilo2.quebec_seven = quebec_sierra3.romeo_lima)
4. 24.339 497.600 ↓ 1,539.1 53,869 1

Nested Loop (cost=14.800..78,425.990 rows=35 width=20) (actual time=46.935..497.600 rows=53,869 loops=1)

5. 7.937 258.026 ↓ 453.1 43,047 1

Nested Loop (cost=14.230..76,236.150 rows=95 width=16) (actual time=46.924..258.026 rows=43,047 loops=1)

6. 17.900 56.651 ↓ 276.3 27,634 1

HashAggregate (cost=13.660..16.160 rows=100 width=12) (actual time=46.881..56.651 rows=27,634 loops=1)

  • Group Key: ((juliet_india1.six_mike ->> 'yankee_foxtrot'::text))::integer, ((juliet_india1.six_mike ->> 'hotel'::text))::double precision
7. 23.458 38.751 ↓ 100.0 30,000 1

Nested Loop (cost=0.000..12.160 rows=300 width=12) (actual time=5.160..38.751 rows=30,000 loops=1)

8. 0.017 0.017 ↑ 1.0 3 1

Seq Scan on oscar_yankee (cost=0.000..1.660 rows=3 width=21) (actual time=0.010..0.017 rows=3 loops=1)

  • Filter: (juliet_victor = 1095)
  • Rows Removed by Filter: 61
9. 15.276 15.276 ↓ 100.0 10,000 3

Function Scan on charlie yankee_charlie (cost=0.000..1.000 rows=100 width=32) (actual time=4.397..5.092 rows=10,000 loops=3)

10. 193.438 193.438 ↓ 2.0 2 27,634

Index Scan using romeo_sierra on delta yankee_xray (cost=0.570..762.180 rows=1 width=8) (actual time=0.006..0.007 rows=2 loops=27,634)

  • Index Cond: (xray_india = (((juliet_india1.six_mike ->> 'yankee_foxtrot'::text))::integer))
  • Filter: ((lima_sierra(papa, yankee_kilo) <= 'lima_xray'::date) AND (lima_sierra(papa, yankee_kilo) >= 'xray_three'::date))
  • Rows Removed by Filter: 2
11. 215.235 215.235 ↑ 1.0 1 43,047

Index Scan using alpha_romeo on tango three_november (cost=0.570..23.040 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=43,047)

  • Index Cond: (romeo_lima = kilo2.quebec_seven)
  • Filter: (oscar_india ~~ 'six_kilo'::text)
  • Rows Removed by Filter: 1
12. 484.821 484.821 ↓ 1.3 4 53,869

Index Scan using three_hotel on five uniform (cost=0.570..32.220 rows=3 width=4) (actual time=0.006..0.009 rows=4 loops=53,869)

  • Index Cond: (romeo_lima = alpha_quebec4.romeo_lima)
  • Filter: ((lima_romeo ~~ 'sierra'::text) OR (lima_romeo ~~ 'romeo_two'::text))
  • Rows Removed by Filter: 6
Planning time : 2.380 ms
Execution time : 1,084.845 ms