explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uop6

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 10,821.024 ↑ 1.0 24 1

Limit (cost=55,827.86..1,384,456.51 rows=24 width=228) (actual time=438.233..10,821.024 rows=24 loops=1)

2. 0.146 10,821.009 ↑ 927.2 24 1

Nested Loop (cost=55,827.86..1,232,026,736.75 rows=22,254 width=228) (actual time=438.231..10,821.009 rows=24 loops=1)

3. 0.125 10,819.927 ↑ 927.2 24 1

Nested Loop (cost=55,827.44..1,231,883,035.74 rows=22,254 width=229) (actual time=438.185..10,819.927 rows=24 loops=1)

4. 0.305 2.527 ↑ 890.2 25 1

Bitmap Heap Scan on salestransaction aa (cost=472.06..3,852.87 rows=22,254 width=160) (actual time=2.491..2.527 rows=25 loops=1)

  • Recheck Cond: ((start_action_date > '2019-10-31 21:00:00'::timestamp without time zone) AND (start_action_date < '2019-11-29 20:59:59'::timestamp without time zone))
  • Heap Blocks: exact=3
5. 2.222 2.222 ↑ 1.0 21,821 1

Bitmap Index Scan on salestransaction_startactiondate_ix (cost=0.00..466.50 rows=22,254 width=0) (actual time=2.222..2.222 rows=21,821 loops=1)

  • Index Cond: ((start_action_date > '2019-10-31 21:00:00'::timestamp without time zone) AND (start_action_date < '2019-11-29 20:59:59'::timestamp without time zone))
6. 0.150 10,817.275 ↑ 1.0 1 25

Limit (cost=55,355.38..55,355.39 rows=1 width=109) (actual time=432.691..432.691 rows=1 loops=25)

7. 0.575 10,817.125 ↑ 9.0 1 25

Sort (cost=55,355.38..55,355.40 rows=9 width=109) (actual time=432.685..432.685 rows=1 loops=25)

  • Sort Key: videoexporthistory_v2.actiontime
  • Sort Method: top-N heapsort Memory: 25kB
8. 1.225 10,816.550 ↑ 1.1 8 25

Append (cost=0.00..55,355.34 rows=9 width=109) (actual time=416.932..432.662 rows=8 loops=25)

9. 0.000 0.000 ↓ 0.0 0 25

Seq Scan on videoexporthistory_v2 (cost=0.00..0.00 rows=1 width=108) (actual time=0.000..0.000 rows=0 loops=25)

  • Filter: (aa.id = relatedactionid)
10. 10,815.325 10,815.325 ↑ 1.0 8 25

Seq Scan on videoexporthistory_v2_0 (cost=0.00..55,355.34 rows=8 width=109) (actual time=416.885..432.613 rows=8 loops=25)

  • Filter: (aa.id = relatedactionid)
  • Rows Removed by Filter: 967967
11. 0.096 0.936 ↑ 1.0 1 24

Limit (cost=0.42..6.44 rows=1 width=49) (actual time=0.039..0.039 rows=1 loops=24)

12. 0.840 0.840 ↑ 2.0 1 24

Index Scan using salestransactionpayment_salestransaction_id_ix on salestransactionpayment (cost=0.42..12.45 rows=2 width=49) (actual time=0.035..0.035 rows=1 loops=24)

  • Index Cond: (aa.id = salestransaction_id)
Planning time : 0.608 ms
Execution time : 10,821.288 ms