explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JuI8

Settings
# exclusive inclusive rows x rows loops node
1. 828.490 2,549.149 ↑ 1.0 38,915 1

HashAggregate (cost=147,815.98..148,205.13 rows=38,915 width=8) (actual time=2,539.484..2,549.149 rows=38,915 loops=1)

  • Group Key: zonfpverzi1_.id
2. 863.381 1,720.659 ↓ 1.0 4,603,190 1

Hash Right Join (cost=4,230.86..136,699.11 rows=4,446,749 width=8) (actual time=59.185..1,720.659 rows=4,603,190 loops=1)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
3. 426.563 798.586 ↓ 1.0 1,768,194 1

Merge Left Join (cost=2.81..77,132.71 rows=1,739,340 width=8) (actual time=0.028..798.586 rows=1,768,194 loops=1)

  • Merge Cond: (podmienkyp7_.id = dokumenty8_.podmienkapomocidokumentzonfp_id)
4. 152.648 152.648 ↑ 1.0 756,771 1

Index Scan using d_podmienkapomocidokument_pkey on d_podmienkapomocidokumentzonfp podmienkyp7_ (cost=0.42..20,038.50 rows=756,771 width=16) (actual time=0.013..152.648 rows=756,771 loops=1)

5. 219.375 219.375 ↑ 1.0 1,739,340 1

Index Only Scan using podmienkapomocidokumentzonfp_to_dokument__dokument_id_idx on podmienkapomocidokumentzonfp_to_dokument dokumenty8_ (cost=0.43..33,460.53 rows=1,739,340 width=16) (actual time=0.011..219.375 rows=1,739,340 loops=1)

  • Heap Fetches: 0
6. 16.207 58.692 ↑ 1.0 99,489 1

Hash (cost=2,984.43..2,984.43 rows=99,489 width=8) (actual time=58.692..58.692 rows=99,489 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4911kB
7. 27.437 42.485 ↑ 1.0 99,489 1

Hash Right Join (cost=1,190.35..2,984.43 rows=99,489 width=8) (actual time=8.651..42.485 rows=99,489 loops=1)

  • Hash Cond: (dokumenty5_.zonfpverzia_id = zonfpverzi1_.id)
8. 6.660 6.660 ↑ 1.0 99,489 1

Seq Scan on zonfpverzia_to_dokument dokumenty5_ (cost=0.00..1,532.89 rows=99,489 width=16) (actual time=0.024..6.660 rows=99,489 loops=1)

9. 5.339 8.388 ↑ 1.0 38,915 1

Hash (cost=703.91..703.91 rows=38,915 width=8) (actual time=8.387..8.388 rows=38,915 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2033kB
10. 3.049 3.049 ↑ 1.0 38,915 1

Index Only Scan using d_zonfpverzia_pkey on d_zonfpverzia zonfpverzi1_ (cost=0.29..703.91 rows=38,915 width=8) (actual time=0.019..3.049 rows=38,915 loops=1)

  • Heap Fetches: 0