#	exclusive	inclusive	rows x	rows	loops	node
1.	0.017	48,178.915	↓ 1.1	41	1	→ Sort (cost=1,575,555,184,068.74..1,575,555,184,068.83 rows=39 width=20) (actual time=48,178.913..48,178.915 rows=41 loops=1) Sort Key: orders.campaign_id Sort Method: quicksort Memory: 26kB
2.	1,560.612	48,178.898	↓ 1.1	41	1	→ HashAggregate (cost=1,575,555,184,067.12..1,575,555,184,067.71 rows=39 width=20) (actual time=48,178.878..48,178.898 rows=41 loops=1) Group Key: orders.campaign_id
3.	1,162.915	46,618.286	↑ 97,987,749.2	1,283,309	1	→ Nested Loop (cost=1,252.27..3,698,177,798.12 rows=125,748,560,501,520 width=20) (actual time=0.634..46,618.286 rows=1,283,309 loops=1)
4.	619.449	3,508.292	↑ 1.1	1,446,451	1	→ Hash Join (cost=1,251.70..324,589.87 rows=1,624,788 width=25) (actual time=0.609..3,508.292 rows=1,446,451 loops=1) Hash Cond: (orders.campaign_id = campaigns.id)
5.	2,888.254	2,888.254	↑ 1.0	1,605,476	1	→ Seq Scan on orders (cost=0.00..302,271.68 rows=1,624,788 width=25) (actual time=0.010..2,888.254 rows=1,605,476 loops=1) Filter: ((action_id IS NOT NULL) AND (campaign_id > 0) AND ((action_id)::text <> '-1'::text) AND ((action_id)::text <> ''::text) AND ((action_id)::text <> 'NONE'::text)) Rows Removed by Filter: 1999491
6.	0.051	0.589	↑ 1.0	188	1	→ Hash (cost=1,249.35..1,249.35 rows=188 width=4) (actual time=0.589..0.589 rows=188 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 27kB
7.	0.538	0.538	↑ 1.0	188	1	→ Index Scan using campaigns_pkey on campaigns (cost=0.27..1,249.35 rows=188 width=4) (actual time=0.004..0.538 rows=188 loops=1) Filter: (status = 1) Rows Removed by Filter: 16
8.	41,947.079	41,947.079	↑ 82,627.0	1	1,446,451	→ Index Scan using order_actions_action_id_idx on order_actions (cost=0.57..1,449.63 rows=82,627 width=13) (actual time=0.029..0.029 rows=1 loops=1,446,451) Index Cond: ((action_id)::text = (orders.action_id)::text)

Planning time	:	1.374 ms
Execution time	:	48,179.008 ms

 Sort  (cost=1575555184068.74..1575555184068.83 rows=39 width=20) (actual time=48178.913..48178.915 rows=41 loops=1)
   Sort Key: orders.campaign_id
   Sort Method: quicksort  Memory: 26kB
   ->  HashAggregate  (cost=1575555184067.12..1575555184067.71 rows=39 width=20) (actual time=48178.878..48178.898 rows=41 loops=1)
         Group Key: orders.campaign_id
         ->  Nested Loop  (cost=1252.27..3698177798.12 rows=125748560501520 width=20) (actual time=0.634..46618.286 rows=1283309 loops=1)
               ->  Hash Join  (cost=1251.70..324589.87 rows=1624788 width=25) (actual time=0.609..3508.292 rows=1446451 loops=1)
                     Hash Cond: (orders.campaign_id = campaigns.id)
                     ->  Seq Scan on orders  (cost=0.00..302271.68 rows=1624788 width=25) (actual time=0.010..2888.254 rows=1605476 loops=1)
                           Filter: ((action_id IS NOT NULL) AND (campaign_id > 0) AND ((action_id)::text <> '-1'::text) AND ((action_id)::text <> ''::text) AND ((action_id)::text <> 'NONE'::text))
                           Rows Removed by Filter: 1999491
                     ->  Hash  (cost=1249.35..1249.35 rows=188 width=4) (actual time=0.589..0.589 rows=188 loops=1)
                           Buckets: 1024  Batches: 1  Memory Usage: 27kB
                           ->  Index Scan using campaigns_pkey on campaigns  (cost=0.27..1249.35 rows=188 width=4) (actual time=0.004..0.538 rows=188 loops=1)
                                 Filter: (status = 1)
                                 Rows Removed by Filter: 16
               ->  Index Scan using order_actions_action_id_idx on order_actions  (cost=0.57..1449.63 rows=82627 width=13) (actual time=0.029..0.029 rows=1 loops=1446451)
                     Index Cond: ((action_id)::text = (orders.action_id)::text)
 Planning time: 1.374 ms
 Execution time: 48179.008 ms

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.051 ms	0.0 %
Hash Join	1	619.449 ms	1.3 %
HashAggregate	1	1,560.612 ms	3.2 %
Index Scan	2	41,947.617 ms	87.1 %
Nested Loop	1	1,162.915 ms	2.4 %
Seq Scan	1	2,888.254 ms	6.0 %
Sort	1	0.017 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
campaigns	1	0.538 ms	0.0 %
Index Scan	1	0.538 ms	100.0 %
order_actions	1	41,947.079 ms	87.1 %
Index Scan	1	41,947.079 ms	100.0 %
orders	1	2,888.254 ms	6.0 %
Seq Scan	1	2,888.254 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HyKh

Color mode:

Visible columns:

Per node type stats

Per table stats