explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kNrp

Settings
# exclusive inclusive rows x rows loops node
1. 0.292 13.574 ↑ 1.0 2 1

HashAggregate (cost=1,888.59..1,888.61 rows=2 width=31) (actual time=13.574..13.574 rows=2 loops=1)

  • Output: fs.identifier, count(fs.*)
  • Group Key: fs.identifier
2. 0.731 13.282 ↓ 1.0 1,804 1

Hash Join (cost=1,440.39..1,879.75 rows=1,767 width=407) (actual time=10.315..13.282 rows=1,804 loops=1)

  • Output: fs.identifier, fs.*
  • Inner Unique: true
  • Hash Cond: (((tuh.campaign_schedule_job_group)::text = (tcs.job_group)::text) AND ((tuh.campaign_schedule_job_name)::text = (tcs.job_name)::text) AND ((tuh.campaign_schedule_sched_name)::text = (tcs.sched_name)::text))
3. 1.400 5.720 ↓ 1.0 1,804 1

Hash Join (cost=843.91..1,269.36 rows=1,767 width=490) (actual time=3.439..5.720 rows=1,804 loops=1)

  • Output: fs.identifier, fs.*, tuh.campaign_schedule_job_group, tuh.campaign_schedule_job_name, tuh.campaign_schedule_sched_name
  • Hash Cond: (tuh.id = fs.user_history_id)
4. 0.914 0.914 ↑ 1.0 12,439 1

Seq Scan on public.telex_user_history tuh (cost=0.00..360.93 rows=12,493 width=91) (actual time=0.015..0.914 rows=12,439 loops=1)

  • Output: tuh.id, tuh.user_info_id, tuh.system, tuh.campaign_schedule_job_name, tuh.campaign_schedule_job_group, tuh.campaign_schedule_sched_name, tuh.created_on
5. 0.606 3.406 ↓ 1.0 1,804 1

Hash (cost=821.82..821.82 rows=1,767 width=415) (actual time=3.405..3.406 rows=1,804 loops=1)

  • Output: fs.identifier, fs.*, fs.user_history_id
  • Buckets: 2,048 Batches: 1 Memory Usage: 837kB
6. 2.800 2.800 ↓ 1.0 1,804 1

Seq Scan on public.telex_file_statistic fs (cost=0.00..821.82 rows=1,767 width=415) (actual time=0.013..2.800 rows=1,804 loops=1)

  • Output: fs.identifier, fs.*, fs.user_history_id
  • Filter: fs.delivered
  • Rows Removed by Filter: 10,499
7. 3.673 6.831 ↓ 1.0 11,150 1

Hash (cost=401.38..401.38 rows=11,149 width=83) (actual time=6.831..6.831 rows=11,150 loops=1)

  • Output: tcs.job_group, tcs.job_name, tcs.sched_name
  • Buckets: 16,384 Batches: 1 Memory Usage: 1,390kB
8. 3.158 3.158 ↓ 1.0 11,150 1

Seq Scan on public.telex_campaign_schedule tcs (cost=0.00..401.38 rows=11,149 width=83) (actual time=0.012..3.158 rows=11,150 loops=1)

  • Output: tcs.job_group, tcs.job_name, tcs.sched_name
  • Filter: (tcs.modified_date >= '2020-10-10 00:00:00'::timestamp without time zone)
Planning time : 0.555 ms
Execution time : 14.148 ms