explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lOYt

Settings
# exclusive inclusive rows x rows loops node
1. 71.383 351.557 ↑ 1.4 172,866 1

Nested Loop (cost=2,263.50..27,065.45 rows=239,291 width=277) (actual time=41.153..351.557 rows=172,866 loops=1)

  • Buffers: shared hit=32109 read=5058
2. 38.012 122.683 ↑ 1.4 8,289 1

Hash Join (cost=2,263.07..5,336.95 rows=11,355 width=233) (actual time=41.037..122.683 rows=8,289 loops=1)

  • Hash Cond: (d.idx = dep.dienstindex)
  • Buffers: shared hit=6 read=2302
3. 48.663 48.663 ↑ 1.0 118,492 1

Seq Scan on mdv_dienst d (cost=0.00..2,534.92 rows=118,492 width=123) (actual time=4.579..48.663 rows=118,492 loops=1)

  • Buffers: shared hit=2 read=1348
4. 4.788 36.008 ↑ 1.4 8,289 1

Hash (cost=2,121.13..2,121.13 rows=11,355 width=110) (actual time=36.008..36.008 rows=8,289 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1224kB
  • Buffers: shared hit=1 read=954
5. 29.384 31.220 ↑ 1.0 11,323 1

Bitmap Heap Scan on mdv_disposition dep (cost=244.81..2,121.13 rows=11,355 width=110) (actual time=1.990..31.220 rows=11,323 loops=1)

  • Recheck Cond: ((datum >= '2019-08-01'::date) AND (datum <= '2019-08-31'::date))
  • Heap Blocks: exact=922
  • Buffers: shared hit=1 read=954
6. 1.836 1.836 ↑ 1.0 11,323 1

Bitmap Index Scan on i_disposition_datum (cost=0.00..241.97 rows=11,355 width=0) (actual time=1.836..1.836 rows=11,323 loops=1)

  • Index Cond: ((datum >= '2019-08-01'::date) AND (datum <= '2019-08-31'::date))
  • Buffers: shared read=33
7. 157.491 157.491 ↑ 1.1 21 8,289

Index Scan using i_dienstregister_dienst on mdv_dienstregister r (cost=0.43..1.68 rows=23 width=44) (actual time=0.010..0.019 rows=21 loops=8,289)

  • Index Cond: (dienstindex = d.idx)
  • Buffers: shared hit=32103 read=2756