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 22,112.308 ↑ 1.0 1 1

Unique (cost=932,495.000..932,514.790 rows=1 width=40) (actual time=22,111.958..22,112.308 rows=1 loops=1)

2. 4.039 22,112.046 ↑ 2.0 1,333 1

Sort (cost=932,495.000..932,501.590 rows=2,639 width=40) (actual time=22,111.957..22,112.046 rows=1,333 loops=1)

  • Sort Key: five_sierra0kilo_oscar.echo, five_sierra0kilo_oscar.quebec
  • Sort Method: quicksort Memory: 153kB
3. 0.210 22,108.007 ↑ 2.0 1,333 1

Nested Loop (cost=0.000..932,345.030 rows=2,639 width=40) (actual time=21,647.238..22,108.007 rows=1,333 loops=1)

4. 0.003 22,107.547 ↑ 1.0 1 1

Nested Loop (cost=0.000..932,190.250 rows=1 width=40) (actual time=21,647.233..22,107.547 rows=1 loops=1)

5. 0.003 22,107.507 ↑ 1.0 1 1

Nested Loop (cost=0.000..932,185.970 rows=1 width=48) (actual time=21,647.194..22,107.507 rows=1 loops=1)

6. 6.275 22,107.458 ↑ 1.0 1 1

Nested Loop (cost=0.000..932,185.440 rows=1 width=64) (actual time=21,647.147..22,107.458 rows=1 loops=1)

7. 676.485 22,061.256 ↓ 831.8 13,309 1

Nested Loop (cost=0.000..932,180.730 rows=16 width=48) (actual time=0.087..22,061.256 rows=13,309 loops=1)

  • Join Filter: (five_sierra0kilo_oscar.xray = papa5kilo_oscar.xray)
8. 4.527 4.527 ↓ 1,187.0 1,187 1

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

  • Filter: ((tango five_romeo NULL) AND ((juliet)::text = 'victor_delta'::text) AND (victor_alpha = ANY ('alpha_two'::bigint[])))
9. 5,047.124 21,380.244 ↓ 1.1 3,438 1,187

Seq Scan on kilo_romeo two_victor (cost=0.000..931,962.990 rows=3,190 width=16) (actual time=0.014..18.012 rows=3,438 loops=1,187)

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

SubPlan (forSeq Scan)

11. 4,083.280 16,333.120 ↑ 1.0 1 4,083,280

Aggregate (cost=97.350..97.360 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4,083,280)

12. 4,083.280 12,249.840 ↑ 37.0 3 4,083,280

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=4,083,280)

  • Recheck Cond: ($0 = yankee)
13. 8,166.560 8,166.560 ↑ 37.0 3 4,083,280

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

  • Index Cond: ($0 = yankee)
14. 39.927 39.927 ↓ 0.0 0 13,309

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=13,309)

  • 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 1,333 1

Seq Scan on four_xray seven_four (cost=0.000..128.390 rows=2,639 width=0) (actual time=0.002..0.250 rows=1,333 loops=1)