#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	16,075.920	↑ 1.0	24	1	→ Limit (cost=442,292.95..442,293.01 rows=24 width=227) (actual time=16,075.917..16,075.920 rows=24 loops=1)
2.	49.756	16,075.918	↑ 30.3	24	1	→ Sort (cost=442,292.95..442,294.77 rows=727 width=227) (actual time=16,075.916..16,075.918 rows=24 loops=1) Sort Key: cc.start_action_date Sort Method: top-N heapsort Memory: 33kB
3.	30.373	16,026.162	↓ 199.9	145,343	1	→ Subquery Scan on cc (cost=432,534.19..442,272.65 rows=727 width=227) (actual time=14,767.934..16,026.162 rows=145,343 loops=1) Filter: ((cc.start_action_date >= '2019-01-31 21:00:00'::timestamp without time zone) AND (cc.start_action_date <= '2019-11-30 20:59:59'::timestamp without time zone))
4.	101.565	15,995.789	↑ 1.0	145,343	1	→ Unique (cost=432,534.19..440,092.51 rows=145,343 width=235) (actual time=14,767.928..15,995.789 rows=145,343 loops=1)
5.	14,391.774	15,894.224	↓ 1.0	1,513,804	1	→ Sort (cost=432,534.19..436,313.35 rows=1,511,664 width=235) (actual time=14,767.927..15,894.224 rows=1,513,804 loops=1) Sort Key: aa.id, bb.actiontime Sort Method: external merge Disk: 412400kB
6.	855.251	1,502.450	↓ 1.0	1,513,804	1	→ Hash Right Join (cost=19,446.75..106,873.22 rows=1,511,664 width=235) (actual time=344.403..1,502.450 rows=1,513,804 loops=1) Hash Cond: (bb.relatedactionid = aa.id)
7.	44.764	305.836	↑ 1.0	967,975	1	→ Append (cost=0.00..52,933.27 rows=968,828 width=109) (actual time=0.005..305.836 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.	261.072	261.072	↑ 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.004..261.072 rows=967,975 loops=1)
10.	90.923	341.363	↑ 1.0	226,776	1	→ Hash (cost=16,612.01..16,612.01 rows=226,779 width=167) (actual time=341.363..341.363 rows=226,776 loops=1) Buckets: 32768 Batches: 1 Memory Usage: 41102kB
11.	195.512	250.440	↑ 1.0	226,776	1	→ Hash Right Join (cost=6,317.22..16,612.01 rows=226,779 width=167) (actual time=39.657..250.440 rows=226,776 loops=1) Hash Cond: (salestransactionpayment.salestransaction_id = aa.id)
12.	15.327	15.327	↑ 1.0	226,779	1	→ Seq Scan on salestransactionpayment (cost=0.00..4,908.79 rows=226,779 width=49) (actual time=0.004..15.327 rows=226,779 loops=1)
13.	27.881	39.601	↑ 1.0	145,343	1	→ Hash (cost=4,500.43..4,500.43 rows=145,343 width=160) (actual time=39.601..39.601 rows=145,343 loops=1) Buckets: 16384 Batches: 1 Memory Usage: 24121kB
14.	11.720	11.720	↑ 1.0	145,343	1	→ Seq Scan on salestransaction aa (cost=0.00..4,500.43 rows=145,343 width=160) (actual time=0.003..11.720 rows=145,343 loops=1)

Planning time	:	0.549 ms
Execution time	:	16,144.274 ms

Limit  (cost=442292.95..442293.01 rows=24 width=227) (actual time=16075.917..16075.920 rows=24 loops=1)
  ->  Sort  (cost=442292.95..442294.77 rows=727 width=227) (actual time=16075.916..16075.918 rows=24 loops=1)
        Sort Key: cc.start_action_date
        Sort Method: top-N heapsort  Memory: 33kB
        ->  Subquery Scan on cc  (cost=432534.19..442272.65 rows=727 width=227) (actual time=14767.934..16026.162 rows=145343 loops=1)
              Filter: ((cc.start_action_date >= '2019-01-31 21:00:00'::timestamp without time zone) AND (cc.start_action_date <= '2019-11-30 20:59:59'::timestamp without time zone))
              ->  Unique  (cost=432534.19..440092.51 rows=145343 width=235) (actual time=14767.928..15995.789 rows=145343 loops=1)
                    ->  Sort  (cost=432534.19..436313.35 rows=1511664 width=235) (actual time=14767.927..15894.224 rows=1513804 loops=1)
                          Sort Key: aa.id, bb.actiontime
                          Sort Method: external merge  Disk: 412400kB
                          ->  Hash Right Join  (cost=19446.75..106873.22 rows=1511664 width=235) (actual time=344.403..1502.450 rows=1513804 loops=1)
                                Hash Cond: (bb.relatedactionid = aa.id)
                                ->  Append  (cost=0.00..52933.27 rows=968828 width=109) (actual time=0.005..305.836 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.004..261.072 rows=967975 loops=1)
                                ->  Hash  (cost=16612.01..16612.01 rows=226779 width=167) (actual time=341.363..341.363 rows=226776 loops=1)
                                      Buckets: 32768  Batches: 1  Memory Usage: 41102kB
                                      ->  Hash Right Join  (cost=6317.22..16612.01 rows=226779 width=167) (actual time=39.657..250.440 rows=226776 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.004..15.327 rows=226779 loops=1)
                                            ->  Hash  (cost=4500.43..4500.43 rows=145343 width=160) (actual time=39.601..39.601 rows=145343 loops=1)
                                                  Buckets: 16384  Batches: 1  Memory Usage: 24121kB
                                                  ->  Seq Scan on salestransaction aa  (cost=0.00..4500.43 rows=145343 width=160) (actual time=0.003..11.720 rows=145343 loops=1)
Planning time: 0.549 ms
Execution time: 16144.274 ms

Per node type stats

node type	count	sum of times	% of query
Append	1	44.764 ms	0.3 %
Hash	2	118.804 ms	0.7 %
Hash Right Join	2	1,050.763 ms	6.5 %
Limit	1	0.002 ms	0.0 %
Seq Scan	4	288.119 ms	1.8 %
Sort	2	14,441.530 ms	89.8 %
Subquery Scan	1	30.373 ms	0.2 %
Unique	1	101.565 ms	0.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
salestransaction	1	11.720 ms	0.1 %
Seq Scan	1	11.720 ms	100.0 %
salestransactionpayment	1	15.327 ms	0.1 %
Seq Scan	1	15.327 ms	100.0 %
videoexporthistory_v2	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
videoexporthistory_v2_0	1	261.072 ms	1.6 %
Seq Scan	1	261.072 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8guN

Color mode:

Visible columns:

Per node type stats

Per table stats