explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uYMI

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1,846.315 ↑ 1.0 24 1

Limit (cost=101,792.64..101,792.70 rows=24 width=227) (actual time=1,846.313..1,846.315 rows=24 loops=1)

2. 6.844 1,846.314 ↑ 927.3 24 1

Sort (cost=101,792.64..101,848.28 rows=22,255 width=227) (actual time=1,846.313..1,846.314 rows=24 loops=1)

  • Sort Key: cc.start_action_date
  • Sort Method: top-N heapsort Memory: 33kB
3. 3.592 1,839.470 ↑ 1.0 21,821 1

Subquery Scan on cc (cost=99,791.34..101,171.17 rows=22,255 width=227) (actual time=1,790.004..1,839.470 rows=21,821 loops=1)

4. 21.448 1,835.878 ↑ 1.0 21,821 1

Unique (cost=99,791.34..100,948.62 rows=22,255 width=235) (actual time=1,790.002..1,835.878 rows=21,821 loops=1)

5. 1,241.841 1,814.430 ↓ 1.1 245,113 1

Sort (cost=99,791.34..100,369.98 rows=231,457 width=235) (actual time=1,790.001..1,814.430 rows=245,113 loops=1)

  • Sort Key: aa.id, bb.actiontime
  • Sort Method: quicksort Memory: 132386kB
6. 261.846 572.589 ↓ 1.1 245,113 1

Hash Right Join (cost=11,809.88..79,168.07 rows=231,457 width=235) (actual time=116.802..572.589 rows=245,113 loops=1)

  • Hash Cond: (bb.relatedactionid = aa.id)
7. 34.373 236.348 ↑ 1.0 967,975 1

Append (cost=0.00..52,933.27 rows=968,828 width=109) (actual time=0.004..236.348 rows=967,975 loops=1)

8. 0.000 0.000 ↓ 0.0 0 1

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

9. 201.975 201.975 ↑ 1.0 967,975 1

Seq Scan on videoexporthistory_v2_0 bb_1 (cost=0.00..52,933.27 rows=968,827 width=109) (actual time=0.003..201.975 rows=967,975 loops=1)

10. 11.697 74.395 ↑ 1.0 33,172 1

Hash (cost=11,375.84..11,375.84 rows=34,723 width=167) (actual time=74.395..74.395 rows=33,172 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 6029kB
11. 41.389 62.698 ↑ 1.0 33,172 1

Hash Right Join (cost=4,135.51..11,375.84 rows=34,723 width=167) (actual time=46.922..62.698 rows=33,172 loops=1)

  • Hash Cond: (salestransactionpayment.salestransaction_id = aa.id)
12. 12.409 12.409 ↑ 1.0 226,779 1

Seq Scan on salestransactionpayment (cost=0.00..4,908.79 rows=226,779 width=49) (actual time=0.007..12.409 rows=226,779 loops=1)

13. 4.488 8.900 ↑ 1.0 21,821 1

Hash (cost=3,857.33..3,857.33 rows=22,254 width=160) (actual time=8.900..8.900 rows=21,821 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 3627kB
14. 3.192 4.412 ↑ 1.0 21,821 1

Bitmap Heap Scan on salestransaction aa (cost=476.52..3,857.33 rows=22,254 width=160) (actual time=1.362..4.412 rows=21,821 loops=1)

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

Bitmap Index Scan on salestransaction_startactiondate_ix (cost=0.00..470.96 rows=22,254 width=0) (actual time=1.220..1.220 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-30 20:59:59'::timestamp without time zone))
Planning time : 0.592 ms
Execution time : 1,860.623 ms