explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zcgE

Settings
# exclusive inclusive rows x rows loops node
1. 2.002 15,050.621 ↑ 1.0 45 1

Limit (cost=1,358,416.72..1,358,421.97 rows=45 width=180) (actual time=15,003.836..15,050.621 rows=45 loops=1)

2. 0.000 15,048.619 ↑ 8,283.6 45 1

Gather Merge (cost=1,358,416.72..1,401,908.42 rows=372,760 width=180) (actual time=15,003.834..15,048.619 rows=45 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 330.252 44,995.356 ↑ 5,481.8 34 3

Sort (cost=1,357,416.69..1,357,882.64 rows=186,380 width=180) (actual time=14,998.449..14,998.452 rows=34 loops=3)

  • Sort Key: teaser.created_at DESC
  • Sort Method: top-N heapsort Memory: 53kB
  • Worker 0: Sort Method: top-N heapsort Memory: 52kB
  • Worker 1: Sort Method: top-N heapsort Memory: 53kB
4. 2,455.011 44,665.104 ↓ 1.2 221,525 3

Parallel Hash Join (cost=1,227,445.31..1,351,366.93 rows=186,380 width=180) (actual time=13,763.885..14,888.368 rows=221,525 loops=3)

  • Hash Cond: (teaser_network_relation.teaser_id = teaser.id)
5. 926.664 926.664 ↑ 1.2 3,123,861 3

Parallel Seq Scan on teaser_network_relation (cost=0.00..98,740.02 rows=3,904,802 width=8) (actual time=0.013..308.888 rows=3,123,861 loops=3)

6. 635.505 41,283.429 ↓ 1.1 274,025 3

Parallel Hash (cost=1,224,464.19..1,224,464.19 rows=238,490 width=188) (actual time=13,761.143..13,761.143 rows=274,025 loops=3)

  • Buckets: 1048576 Batches: 1 Memory Usage: 198912kB
7. 14,992.515 40,647.924 ↓ 1.1 274,025 3

Parallel Hash Join (cost=202,363.21..1,224,464.19 rows=238,490 width=188) (actual time=107.712..13,549.308 rows=274,025 loops=3)

  • Hash Cond: (teaser_country_relation.teaser_id = teaser.id)
8. 25,333.314 25,333.314 ↑ 1.2 29,355,298 3

Parallel Seq Scan on teaser_country_relation (cost=0.00..925,788.30 rows=36,690,530 width=8) (actual time=0.020..8,444.438 rows=29,355,298 loops=3)

9. 38.250 322.095 ↑ 1.2 27,139 3

Parallel Hash (cost=201,957.24..201,957.24 rows=32,478 width=180) (actual time=107.365..107.365 rows=27,139 loops=3)

  • Buckets: 131072 Batches: 1 Memory Usage: 19552kB
10. 263.642 283.845 ↑ 1.2 27,139 3

Parallel Bitmap Heap Scan on teaser (cost=740.33..201,957.24 rows=32,478 width=180) (actual time=36.580..94.615 rows=27,139 loops=3)

  • Recheck Cond: (to_tsvector('russian'::regconfig, (title)::text) @@ plainto_tsquery('first'::text))
  • Heap Blocks: exact=38513
11. 20.203 20.203 ↓ 1.0 81,417 1

Bitmap Index Scan on fts_teaser_title (cost=0.00..720.84 rows=77,946 width=0) (actual time=20.203..20.203 rows=81,417 loops=1)

  • Index Cond: (to_tsvector('russian'::regconfig, (title)::text) @@ plainto_tsquery('first'::text))