explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7WsV

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 26,094.017 ↓ 0.0 0 1

Unique (cost=479,906.10..479,906.32 rows=44 width=8) (actual time=26,094.017..26,094.017 rows=0 loops=1)

2. 0.005 26,094.016 ↓ 0.0 0 1

Sort (cost=479,906.10..479,906.21 rows=44 width=8) (actual time=26,094.016..26,094.016 rows=0 loops=1)

  • Sort Key: zonfpverzi1_.id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 26,094.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=28,314.85..479,904.90 rows=44 width=8) (actual time=26,094.011..26,094.011 rows=0 loops=1)

4. 18,314.820 26,094.010 ↓ 0.0 0 1

Hash Right Join (cost=28,314.56..479,898.13 rows=17 width=8) (actual time=26,094.010..26,094.010 rows=0 loops=1)

  • Hash Cond: (podmienkyp7_.zonfpverzia_id = zonfpverzi1_.id)
  • Filter: (f_unaccent(lower(dokument9_.nazov)) ~~ 'vypis'::text)
  • Rows Removed by Filter: 1769994
5. 1,564.776 7,767.550 ↓ 1.0 1,768,194 1

Hash Right Join (cost=27,124.21..474,130.04 rows=1,739,340 width=45) (actual time=344.918..7,767.550 rows=1,768,194 loops=1)

  • Hash Cond: (dokumenty8_.podmienkapomocidokumentzonfp_id = podmienkyp7_.id)
6. 1,338.097 5,861.005 ↑ 1.0 1,739,340 1

Merge Left Join (cost=0.86..408,168.90 rows=1,739,340 width=45) (actual time=0.165..5,861.005 rows=1,739,340 loops=1)

  • Merge Cond: (dokumenty8_.dokument_id = dokument9_.id)
7. 520.410 520.410 ↑ 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.012..520.410 rows=1,739,340 loops=1)

8. 4,002.498 4,002.498 ↑ 1.0 7,807,009 1

Index Scan using d_dokument_pkey on d_dokument dokument9_ (cost=0.43..326,184.97 rows=7,807,125 width=45) (actual time=0.006..4,002.498 rows=7,807,009 loops=1)

9. 174.694 341.769 ↑ 1.0 756,771 1

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

  • Buckets: 524288 Batches: 4 Memory Usage: 12965kB
10. 167.075 167.075 ↑ 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.054..167.075 rows=756,771 loops=1)

11. 7.740 11.640 ↑ 1.0 38,915 1

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

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

  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0

Index Scan using zonfpverzia_to_dokument__zonfpverzia_id_idx on zonfpverzia_to_dokument dokumenty5_ (cost=0.29..0.37 rows=3 width=16) (never executed)

  • Index Cond: (zonfpverzi1_.id = zonfpverzia_id)