explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ynl4

Settings
# exclusive inclusive rows x rows loops node
1. 131.750 114,609.372 ↑ 1.7 22,638 1

HashAggregate (cost=892,524.52..892,913.67 rows=38,915 width=8) (actual time=114,605.919..114,609.372 rows=22,638 loops=1)

  • Group Key: zonfpverzi1_.id
2. 106,256.821 114,477.622 ↓ 1.5 183,666 1

Hash Left Join (cost=588,047.75..892,222.51 rows=120,803 width=8) (actual time=5,818.510..114,477.622 rows=183,666 loops=1)

  • Hash Cond: (dokumenty8_.dokument_id = dokument9_.id)
  • Filter: ((f_unaccent(lower(dokument9_.nazov)) ~~ '%vypis%'::text) OR (f_unaccent(lower(dokument6_.nazov)) ~~ '%vypis%'::text))
  • Rows Removed by Filter: 4419524
3. 1,024.504 3,633.931 ↓ 1.0 4,603,190 1

Hash Left Join (cost=158,559.31..295,593.84 rows=4,446,749 width=53) (actual time=1,151.967..3,633.931 rows=4,603,190 loops=1)

  • Hash Cond: (zonfpverzi1_.id = dokumenty5_.zonfpverzia_id)
4. 427.061 1,468.738 ↓ 1.0 1,769,994 1

Hash Right Join (cost=1,193.16..82,889.33 rows=1,739,340 width=16) (actual time=10.349..1,468.738 rows=1,769,994 loops=1)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
5. 485.534 1,031.967 ↓ 1.0 1,768,194 1

Merge Left Join (cost=2.81..77,132.71 rows=1,739,340 width=16) (actual time=0.400..1,031.967 rows=1,768,194 loops=1)

  • Merge Cond: (podmienkyp7_.id = dokumenty8_.podmienkapomocidokumentzonfp_id)
6. 256.897 256.897 ↑ 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.053..256.897 rows=756,771 loops=1)

7. 289.536 289.536 ↑ 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.323..289.536 rows=1,739,340 loops=1)

  • Heap Fetches: 0
8. 5.401 9.710 ↑ 1.0 38,915 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2033kB
9. 4.309 4.309 ↑ 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..4.309 rows=38,915 loops=1)

  • Heap Fetches: 0
10. 38.972 1,140.689 ↑ 1.0 99,489 1

Hash (cost=156,122.54..156,122.54 rows=99,489 width=45) (actual time=1,140.689..1,140.689 rows=99,489 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 9993kB
11. 87.866 1,101.717 ↑ 1.0 99,489 1

Nested Loop Left Join (cost=0.43..156,122.54 rows=99,489 width=45) (actual time=0.075..1,101.717 rows=99,489 loops=1)

12. 18.961 18.961 ↑ 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.020..18.961 rows=99,489 loops=1)

13. 994.890 994.890 ↑ 1.0 1 99,489

Index Scan using d_dokument_pkey on d_dokument dokument6_ (cost=0.43..1.55 rows=1 width=45) (actual time=0.010..0.010 rows=1 loops=99,489)

  • Index Cond: (dokumenty5_.dokument_id = id)
14. 2,171.227 4,586.870 ↓ 1.0 7,807,125 1

Hash (cost=263,288.75..263,288.75 rows=7,806,775 width=45) (actual time=4,586.870..4,586.870 rows=7,807,125 loops=1)

  • Buckets: 262144 Batches: 64 Memory Usage: 11361kB
15. 2,415.643 2,415.643 ↓ 1.0 7,807,125 1

Seq Scan on d_dokument dokument9_ (cost=0.00..263,288.75 rows=7,806,775 width=45) (actual time=0.025..2,415.643 rows=7,807,125 loops=1)