explain.depesz.com

PostgreSQL's explain analyze made readable

Result: maYkV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=488,257.95..488,562.03 rows=38,915 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=488,257.95..488,409.99 rows=60,817 width=8) (actual rows= loops=)

  • Sort Key: zonfpverzi1_.id
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=31,091.06..483,425.37 rows=60,817 width=8) (actual rows= loops=)

  • Hash Cond: (zonfpverzi1_.id = dokumenty5_.zonfpverzia_id)
4. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=28,314.56..479,892.01 rows=23,789 width=8) (actual rows= loops=)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
  • Filter: (f_unaccent(lower(dokument9_.nazov)) ~~ '%vypis%'::text)
5. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=27,124.21..474,123.91 rows=1,739,340 width=45) (actual rows= loops=)

  • Hash Cond: (dokumenty8_.podmienkapomocidokumentzonfp_id = podmienkyp7_.id)
6. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=0.86..408,162.78 rows=1,739,340 width=45) (actual rows= loops=)

  • Merge Cond: (dokumenty8_.dokument_id = dokument9_.id)
7. 0.000 0.000 ↓ 0.0

Index Scan using podmienkapomocidokumentzonfp_to_dokument_dokument_id_idx on podmienkapomocidokumentzonfp_to_dokument dokumenty8_ (cost=0.43..40,744.74 rows=1,739,340 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using d_dokument_pkey on d_dokument dokument9_ (cost=0.43..326,179.72 rows=7,806,775 width=45) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=13,967.71..13,967.71 rows=756,771 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on d_podmienkapomocidokumentzonfp podmienkyp7_ (cost=0.00..13,967.71 rows=756,771 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=703.91..703.91 rows=38,915 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

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

13. 0.000 0.000 ↓ 0.0

Hash (cost=1532.89..1532.89 rows=99489 width=16)" -> Seq Scan on zonfpverzia_to_dokument dokumenty5_ (cost=0.00..1,532.89 rows=99,489 width=16) (actual rows= loops=)