explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7B4y

Settings
# exclusive inclusive rows x rows loops node
1. 16.642 31,392.323 ↑ 1.7 22,638 1

Unique (cost=488,257.95..488,562.03 rows=38,915 width=8) (actual time=31,367.820..31,392.323 rows=22,638 loops=1)

2. 89.013 31,375.681 ↓ 3.0 183,666 1

Sort (cost=488,257.95..488,409.99 rows=60,817 width=8) (actual time=31,367.818..31,375.681 rows=183,666 loops=1)

  • Sort Key: zonfpverzi1_.id
  • Sort Method: quicksort Memory: 14754kB
3. 89.796 31,286.668 ↓ 3.0 183,666 1

Hash Left Join (cost=31,091.06..483,425.37 rows=60,817 width=8) (actual time=322.808..31,286.668 rows=183,666 loops=1)

  • Hash Cond: (zonfpverzi1_.id = dokumenty5_.zonfpverzia_id)
4. 22,930.759 31,179.022 ↓ 2.9 69,949 1

Hash Right Join (cost=28,314.56..479,892.01 rows=23,789 width=8) (actual time=304.441..31,179.022 rows=69,949 loops=1)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
  • Filter: (f_unaccent(lower(dokument9_.nazov)) ~~ '%vypis%'::text)
  • Rows Removed by Filter: 1700045
5. 1,807.024 8,236.401 ↓ 1.0 1,768,194 1

Hash Right Join (cost=27,124.21..474,123.91 rows=1,739,340 width=45) (actual time=292.069..8,236.401 rows=1,768,194 loops=1)

  • Hash Cond: (dokumenty8_.podmienkapomocidokumentzonfp_id = podmienkyp7_.id)
6. 1,392.903 6,140.849 ↑ 1.0 1,739,340 1

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

  • Merge Cond: (dokumenty8_.dokument_id = dokument9_.id)
7. 542.400 542.400 ↑ 1.0 1,739,340 1

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 time=0.016..542.400 rows=1,739,340 loops=1)

8. 4,205.546 4,205.546 ↓ 1.0 7,807,009 1

Index Scan using d_dokument_pkey on d_dokument dokument9_ (cost=0.43..326,179.72 rows=7,806,775 width=45) (actual time=0.010..4,205.546 rows=7,807,009 loops=1)

9. 158.136 288.528 ↑ 1.0 756,771 1

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

  • Buckets: 524288 Batches: 4 Memory Usage: 12965kB
10. 130.392 130.392 ↑ 1.0 756,771 1

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

11. 6.891 11.862 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
13. 11.819 17.850 ↑ 1.0 99,489 1

Hash (cost=1,532.89..1,532.89 rows=99,489 width=16) (actual time=17.850..17.850 rows=99,489 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5688kB
14. 6.031 6.031 ↑ 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.012..6.031 rows=99,489 loops=1)