explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yYaS

Settings
# exclusive inclusive rows x rows loops node
1. 7,737.253 8,006.769 ↓ 79.0 140,280 1

Hash Join (cost=942.67..3,001.83 rows=1,776 width=248) (actual time=264.783..8,006.769 rows=140,280 loops=1)

  • Buffers: shared hit=19 read=294 dirtied=10
2. 7.768 7.768 ↑ 1.0 1,972 1

Seq Scan on meta_fiscal mf (cost=0..47.72 rows=1,972 width=34) (actual time=0.38..7.768 rows=1,972 loops=1)

  • Buffers: shared hit=10 read=18 dirtied=10
3. 116.341 261.748 ↓ 79.0 140,280 1

Hash (cost=920.47..920.47 rows=1,776 width=120) (actual time=261.748..261.748 rows=140,280 loops=1)

  • Buffers: shared hit=1 read=276
4. 101.814 145.407 ↓ 79.0 140,280 1

Nested Loop (cost=0..920.47 rows=1,776 width=120) (actual time=5.248..145.407 rows=140,280 loops=1)

  • Buffers: shared hit=1 read=276
5. 26.058 26.058 ↓ 79.0 5,845 1

Seq Scan on meta_date md (cost=0..896.97 rows=74 width=116) (actual time=5.217..26.058 rows=5,845 loops=1)

  • Filter: ((((md.year)::double precision >= (date_part('year'::text, (CURRENT_DATE)::timestamp without time zone) - '10'::double precision)) AND ((md.year)::double precision <= (date_part('year'::text, (CURRENT_DATE)::timestamp without time zone) + '5'::double precision))) OR (md.date = '-infinity'::date))
  • Buffers: shared read=276
6. 17.513 17.535 ↑ 1.0 24 5,845

Materialize (cost=0..1.36 rows=24 width=4) (actual time=0..0.003 rows=24 loops=5,845)

  • Buffers: shared hit=1
7. 0.022 0.022 ↑ 1.0 24 1

Seq Scan on dim_client mc (cost=0..1.24 rows=24 width=4) (actual time=0.016..0.022 rows=24 loops=1)

  • Buffers: shared hit=1