#	exclusive	inclusive	rows x	rows	loops	node
1.	1.846	30,348.280	↓ 0.0	0	1	→ Update on cdr_event (cost=16,885,125.67..16,885,359.03 rows=5,834 width=308) (actual time=30,348.280..30,348.280 rows=0 loops=1)
2.						CTE newer_alert_events
3.	69.999	30,342.263	↑ 142.3	41	1	→ HashAggregate (cost=16,883,520.81..16,883,579.15 rows=5,834 width=16) (actual time=30,342.241..30,342.263 rows=41 loops=1)
4.	29.527	30,272.264	↑ 76.5	175,300	1	→ Nested Loop Left Join (cost=0.57..16,782,893.36 rows=13,416,993 width=16) (actual time=0.977..30,272.264 rows=175,300 loops=1)
5.	2.803	2.803	↓ 1.0	2,239	1	→ Seq Scan on cdr_event cdr_event_1 (cost=0.00..1,523.62 rows=2,197 width=24) (actual time=0.018..2.803 rows=2,239 loops=1) Filter: (state = 'active'::text) Rows Removed by Filter: 37
6.	30,239.934	30,239.934	↑ 185.5	77	2,239	→ Index Scan using index_alert_event_on_adid_and_created_at_and_not_summary on alert_event (cost=0.57..7,495.46 rows=14,285 width=16) (actual time=0.009..13.506 rows=77 loops=2,239) Index Cond: ((cdr_event_1.cdr_alert_id = alert_definition_id) AND (created_at > COALESCE(cdr_event_1.last_active_at, cdr_event_1.created_at)))
7.	0.056	30,346.434	↑ 145.8	40	1	→ Hash Join (cost=1,546.53..1,779.89 rows=5,834 width=308) (actual time=30,346.360..30,346.434 rows=40 loops=1) Hash Cond: (newer_alert_events.alert_definition_id = cdr_event.cdr_alert_id)
8.	30,342.313	30,342.313	↑ 142.3	41	1	→ CTE Scan on newer_alert_events (cost=0.00..116.68 rows=5,834 width=72) (actual time=30,342.267..30,342.313 rows=41 loops=1)
9.	1.594	4.065	↑ 1.2	1,854	1	→ Hash (cost=1,517.90..1,517.90 rows=2,290 width=244) (actual time=4.065..4.065 rows=1,854 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1138kB
10.	2.471	2.471	↑ 1.0	2,276	1	→ Seq Scan on cdr_event (cost=0.00..1,517.90 rows=2,290 width=244) (actual time=0.016..2.471 rows=2,276 loops=1)

QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Update on cdr_event  (cost=16885125.67..16885359.03 rows=5834 width=308) (actual time=30348.280..30348.280 rows=0 loops=1)
   CTE newer_alert_events
     ->  HashAggregate  (cost=16883520.81..16883579.15 rows=5834 width=16) (actual time=30342.241..30342.263 rows=41 loops=1)
           ->  Nested Loop Left Join  (cost=0.57..16782893.36 rows=13416993 width=16) (actual time=0.977..30272.264 rows=175300 loops=1)
                 ->  Seq Scan on cdr_event cdr_event_1  (cost=0.00..1523.62 rows=2197 width=24) (actual time=0.018..2.803 rows=2239 loops=1)
                       Filter: (state = 'active'::text)
                       Rows Removed by Filter: 37
                 ->  Index Scan using index_alert_event_on_adid_and_created_at_and_not_summary on alert_event  (cost=0.57..7495.46 rows=14285 width=16) (actual time=0.009..13.506 rows=77 loops=2239)
                       Index Cond: ((cdr_event_1.cdr_alert_id = alert_definition_id) AND (created_at > COALESCE(cdr_event_1.last_active_at, cdr_event_1.created_at)))
   ->  Hash Join  (cost=1546.53..1779.89 rows=5834 width=308) (actual time=30346.360..30346.434 rows=40 loops=1)
         Hash Cond: (newer_alert_events.alert_definition_id = cdr_event.cdr_alert_id)
         ->  CTE Scan on newer_alert_events  (cost=0.00..116.68 rows=5834 width=72) (actual time=30342.267..30342.313 rows=41 loops=1)
         ->  Hash  (cost=1517.90..1517.90 rows=2290 width=244) (actual time=4.065..4.065 rows=1854 loops=1)
               Buckets: 1024  Batches: 1  Memory Usage: 1138kB
               ->  Seq Scan on cdr_event  (cost=0.00..1517.90 rows=2290 width=244) (actual time=0.016..2.471 rows=2276 loops=1)
 Total runtime: 30348.619 ms
(16 rows)

Per node type stats

node type	count	sum of times	% of query
CTE Scan	1	30,342.313 ms	100.0 %
Hash	1	1.594 ms	0.0 %
Hash Join	1	0.056 ms	0.0 %
HashAggregate	1	69.999 ms	0.2 %
Index Scan	1	30,239.934 ms	99.6 %
Nested Loop Left Join	1	29.527 ms	0.1 %
Seq Scan	2	5.274 ms	0.0 %
Update	1	1.846 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
alert_event	1	30,239.934 ms	99.6 %
Index Scan	1	30,239.934 ms	100.0 %
cdr_event	3	7.120 ms	0.0 %
Seq Scan	2	5.274 ms	74.1 %
Update	1	1.846 ms	25.9 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FQQr

Color mode:

Visible columns:

Per node type stats

Per table stats