explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NPc4

Settings
# exclusive inclusive rows x rows loops node
1. 762,409.147 798,828.519 ↓ 0.0 0 1

Update on fact_spot (cost=1,242,669.39..1,850,747.99 rows=2,224,451 width=474) (actual time=798,828.519..798,828.519 rows=0 loops=1)

2. 11,837.084 36,419.372 ↓ 1.0 2,224,739 1

Hash Join (cost=1,242,669.39..1,850,747.99 rows=2,224,451 width=474) (actual time=23,901.627..36,419.372 rows=2,224,739 loops=1)

  • Hash Cond: (rss.spot_sk = fact_spot.spot_sk)
3. 709.796 709.796 ↓ 1.0 2,224,739 1

Seq Scan on reveal_spot_score rss (cost=0.00..66,372.07 rows=2,224,451 width=52) (actual time=0.006..709.796 rows=2,224,739 loops=1)

  • Filter: (is_tracking_audience = 0)
  • Rows Removed by Filter: 10067
4. 13,520.795 23,872.492 ↓ 1.1 8,923,792 1

Hash (cost=704,923.06..704,923.06 rows=8,497,706 width=389) (actual time=23,872.492..23,872.492 rows=8,923,792 loops=1)

  • Buckets: 16384 Batches: 1024 Memory Usage: 3678kB
5. 10,351.697 10,351.697 ↓ 1.1 8,923,792 1

Seq Scan on fact_spot (cost=0.00..704,923.06 rows=8,497,706 width=389) (actual time=0.003..10,351.697 rows=8,923,792 loops=1)

Planning time : 2.398 ms
Execution time : 799,041.101 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint active_impression_type_sk 210.266 ms 19497 0.011 ms