#	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: 132,386kB
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: 4,096 Batches: 1 Memory Usage: 6,029kB
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: 4,096 Batches: 1 Memory Usage: 3,627kB
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=1,576
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

Limit  (cost=101792.64..101792.70 rows=24 width=227) (actual time=1846.313..1846.315 rows=24 loops=1)
  ->  Sort  (cost=101792.64..101848.28 rows=22255 width=227) (actual time=1846.313..1846.314 rows=24 loops=1)
        Sort Key: cc.start_action_date
        Sort Method: top-N heapsort  Memory: 33kB
        ->  Subquery Scan on cc  (cost=99791.34..101171.17 rows=22255 width=227) (actual time=1790.004..1839.470 rows=21821 loops=1)
              ->  Unique  (cost=99791.34..100948.62 rows=22255 width=235) (actual time=1790.002..1835.878 rows=21821 loops=1)
                    ->  Sort  (cost=99791.34..100369.98 rows=231457 width=235) (actual time=1790.001..1814.430 rows=245113 loops=1)
                          Sort Key: aa.id, bb.actiontime
                          Sort Method: quicksort  Memory: 132386kB
                          ->  Hash Right Join  (cost=11809.88..79168.07 rows=231457 width=235) (actual time=116.802..572.589 rows=245113 loops=1)
                                Hash Cond: (bb.relatedactionid = aa.id)
                                ->  Append  (cost=0.00..52933.27 rows=968828 width=109) (actual time=0.004..236.348 rows=967975 loops=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)
                                      ->  Seq Scan on videoexporthistory_v2_0 bb_1  (cost=0.00..52933.27 rows=968827 width=109) (actual time=0.003..201.975 rows=967975 loops=1)
                                ->  Hash  (cost=11375.84..11375.84 rows=34723 width=167) (actual time=74.395..74.395 rows=33172 loops=1)
                                      Buckets: 4096  Batches: 1  Memory Usage: 6029kB
                                      ->  Hash Right Join  (cost=4135.51..11375.84 rows=34723 width=167) (actual time=46.922..62.698 rows=33172 loops=1)
                                            Hash Cond: (salestransactionpayment.salestransaction_id = aa.id)
                                            ->  Seq Scan on salestransactionpayment  (cost=0.00..4908.79 rows=226779 width=49) (actual time=0.007..12.409 rows=226779 loops=1)
                                            ->  Hash  (cost=3857.33..3857.33 rows=22254 width=160) (actual time=8.900..8.900 rows=21821 loops=1)
                                                  Buckets: 4096  Batches: 1  Memory Usage: 3627kB
                                                  ->  Bitmap Heap Scan on salestransaction aa  (cost=476.52..3857.33 rows=22254 width=160) (actual time=1.362..4.412 rows=21821 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
                                                        ->  Bitmap Index Scan on salestransaction_startactiondate_ix  (cost=0.00..470.96 rows=22254 width=0) (actual time=1.220..1.220 rows=21821 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: 1860.623 ms

Per node type stats

node type	count	sum of times	% of query
Append	1	34.373 ms	1.9 %
Bitmap Heap Scan	1	3.192 ms	0.2 %
Bitmap Index Scan	1	1.220 ms	0.1 %
Hash	2	16.185 ms	0.9 %
Hash Right Join	2	303.235 ms	16.4 %
Limit	1	0.001 ms	0.0 %
Seq Scan	3	214.384 ms	11.6 %
Sort	2	1,248.685 ms	67.6 %
Subquery Scan	1	3.592 ms	0.2 %
Unique	1	21.448 ms	1.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
salestransaction	1	3.192 ms	0.2 %
Bitmap Heap Scan	1	3.192 ms	100.0 %
salestransactionpayment	1	12.409 ms	0.7 %
Seq Scan	1	12.409 ms	100.0 %
videoexporthistory_v2	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
videoexporthistory_v2_0	1	201.975 ms	10.9 %
Seq Scan	1	201.975 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uYMI

Color mode:

Visible columns:

Per node type stats

Per table stats