explain.depesz.com

A tool for finding a real cause for slow queries.

Result: rEK

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.262 22112.308 ↑ 1.0 1 1

Unique (cost=932495.000..932514.790 rows=1 width=40) (actual time=22111.958..22112.308 rows=1 loops=1)

2. 4.039 22112.046 ↑ 2.0 1333 1

Sort (cost=932495.000..932501.590 rows=2639 width=40) (actual time=22111.957..22112.046 rows=1333 loops=1)

  • Sort Key: five_sierra0kilo_oscar.echo, five_sierra0kilo_oscar.quebec
  • Sort Method: quicksort Memory: 153kB
3. 0.210 22108.007 ↑ 2.0 1333 1

Nested Loop (cost=0.000..932345.030 rows=2639 width=40) (actual time=21647.238..22108.007 rows=1333 loops=1)

4. 0.003 22107.547 ↑ 1.0 1 1

Nested Loop (cost=0.000..932190.250 rows=1 width=40) (actual time=21647.233..22107.547 rows=1 loops=1)

5. 0.003 22107.507 ↑ 1.0 1 1

Nested Loop (cost=0.000..932185.970 rows=1 width=48) (actual time=21647.194..22107.507 rows=1 loops=1)

6. 6.275 22107.458 ↑ 1.0 1 1

Nested Loop (cost=0.000..932185.440 rows=1 width=64) (actual time=21647.147..22107.458 rows=1 loops=1)

7. 676.485 22061.256 ↓ 831.8 13309 1

Nested Loop (cost=0.000..932180.730 rows=16 width=48) (actual time=0.087..22061.256 rows=13309 loops=1)

  • Join Filter: (five_sierra0kilo_oscar.xray = papa5kilo_oscar.xray)
8. 4.527 4.527 ↓ 1187.0 1187 1

Seq Scan on four_xray romeo_two (cost=0.000..177.870 rows=1 width=48) (actual time=0.017..4.527 rows=1187 loops=1)

  • Filter: ((tango five_romeo NULL) AND ((juliet)::text = 'victor_delta'::text) AND (victor_alpha = ANY ('alpha_two'::bigint[])))
9. 5047.124 21380.244 ↓ 1.1 3438 1187

Seq Scan on kilo_romeo two_victor (cost=0.000..931962.990 rows=3190 width=16) (actual time=0.014..18.012 rows=3438 loops=1187)

  • Filter: ((two_tango) > 0)
10.          

SubPlan (forSeq Scan)

11. 4083.280 16333.120 ↑ 1.0 1 4083280

Aggregate (cost=97.350..97.360 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4083280)

12. 4083.280 12249.840 ↑ 37.0 3 4083280

Bitmap Heap Scan on four_lima mike (cost=3.110..97.070 rows=111 width=8) (actual time=0.003..0.003 rows=3 loops=4083280)

  • Recheck Cond: ($0 = yankee)
13. 8166.560 8166.560 ↑ 37.0 3 4083280

Bitmap Index Scan on seven_hotel (cost=0.000..3.080 rows=111 width=0) (actual time=0.002..0.002 rows=3 loops=4083280)

  • Index Cond: ($0 = yankee)
14. 39.927 39.927 ↓ 0.0 0 13309

Index Scan using six on india_five india_three (cost=0.000..0.280 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=13309)

  • Index Cond: ((alpha_november3kilo_oscar.romeo_four = 413) AND (alpha_november3kilo_oscar.whiskey_november = papa5kilo_oscar.whiskey_november))
15. 0.046 0.046 ↑ 1.0 1 1

Index Scan using november on alpha_november foxtrot (cost=0.000..0.520 rows=1 width=8) (actual time=0.045..0.046 rows=1 loops=1)

  • Index Cond: (romeo_xray4kilo_oscar.quebec = alpha_november3kilo_oscar.whiskey_november)
16. 0.037 0.037 ↑ 1.0 1 1

Index Scan using whiskey_delta on golf_juliet two_charlie (cost=0.000..4.270 rows=1 width=8) (actual time=0.036..0.037 rows=1 loops=1)

  • Index Cond: (golf_yankee2kilo_oscar.quebec = 413)
17. 0.250 0.250 ↑ 2.0 1333 1

Seq Scan on four_xray seven_four (cost=0.000..128.390 rows=2639 width=0) (actual time=0.002..0.250 rows=1333 loops=1)