explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kCtd

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 29,487.351 ↑ 1.0 1 1

Finalize Aggregate (cost=1,062,982.59..1,062,982.60 rows=1 width=8) (actual time=29,487.351..29,487.351 rows=1 loops=1)

2. 3.300 29,488.523 ↓ 1.5 3 1

Gather (cost=1,062,982.38..1,062,982.59 rows=2 width=8) (actual time=29,487.269..29,488.523 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 62.408 29,485.223 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=1,061,982.38..1,061,982.39 rows=1 width=8) (actual time=29,485.223..29,485.223 rows=1 loops=3)

4. 250.881 29,422.815 ↓ 7.2 790,855 3 / 3

Hash Join (cost=4.70..1,061,708.11 rows=109,705 width=4) (actual time=11,339.581..29,422.815 rows=790,855 loops=3)

  • Hash Cond: (xact_message.templatelanguage_id = xact_templatelanguage.id)
5. 29,171.888 29,171.888 ↑ 1.3 997,256 3 / 3

Parallel Seq Scan on xact_message (cost=0.00..1,055,669.60 rows=1,316,466 width=8) (actual time=11,339.408..29,171.888 rows=997,256 loops=3)

  • Filter: (send_on > '2020-05-31 22:38:27.623399+00'::timestamp with time zone)
  • Rows Removed by Filter: 12,834,830
6. 0.005 0.046 ↑ 1.0 9 3 / 3

Hash (cost=4.59..4.59 rows=9 width=4) (actual time=0.046..0.046 rows=9 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.003 0.041 ↑ 1.0 9 3 / 3

Nested Loop (cost=0.00..4.59 rows=9 width=4) (actual time=0.027..0.041 rows=9 loops=3)

8. 0.017 0.017 ↑ 1.0 1 3 / 3

Seq Scan on xact_template (cost=0.00..1.15 rows=1 width=4) (actual time=0.016..0.017 rows=1 loops=3)

  • Filter: (id = 3)
  • Rows Removed by Filter: 11
9. 0.021 0.021 ↑ 1.0 9 3 / 3

Seq Scan on xact_templatelanguage (cost=0.00..3.35 rows=9 width=8) (actual time=0.009..0.021 rows=9 loops=3)

  • Filter: (template_id = 3)
  • Rows Removed by Filter: 99