explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dicO

Settings
# exclusive inclusive rows x rows loops node
1. 241.324 13,159.411 ↑ 11.3 2,933 1

Finalize GroupAggregate (cost=313,884.80..326,005.72 rows=33,055 width=22) (actual time=11,558.998..13,159.411 rows=2,933 loops=1)

  • Group Key: p.name
  • Filter: (count(*) > 10)
  • Rows Removed by Filter: 1180924
2. 0.000 12,918.087 ↓ 15.0 1,238,977 1

Gather Merge (cost=313,884.80..324,146.36 rows=82,638 width=22) (actual time=11,558.334..12,918.087 rows=1,238,977 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 440.451 34,917.906 ↓ 10.0 412,992 3

Partial GroupAggregate (cost=312,884.78..313,607.86 rows=41,319 width=22) (actual time=11,401.864..11,639.302 rows=412,992 loops=3)

  • Group Key: p.name
4. 9,441.957 34,477.455 ↓ 17.0 703,408 3

Sort (cost=312,884.78..312,988.08 rows=41,319 width=14) (actual time=11,401.855..11,492.485 rows=703,408 loops=3)

  • Sort Key: p.name
  • Sort Method: quicksort Memory: 63599kB
  • Worker 0: Sort Method: quicksort Memory: 61343kB
  • Worker 1: Sort Method: quicksort Memory: 63092kB
5. 1,537.861 25,035.498 ↓ 17.0 703,408 3

Nested Loop (cost=113,513.83..309,716.74 rows=41,319 width=14) (actual time=245.146..8,345.166 rows=703,408 loops=3)

6. 1,091.667 5,747.589 ↓ 17.6 739,585 3

Parallel Hash Join (cost=113,513.39..289,356.69 rows=42,111 width=10) (actual time=244.970..1,915.863 rows=739,585 loops=3)

  • Hash Cond: ((r.title_id)::text = (t.title_id)::text)
7. 2,727.327 4,060.704 ↓ 2.3 1,103,709 3

Parallel Hash Join (cost=12,092.44..186,679.60 rows=478,531 width=30) (actual time=45.442..1,353.568 rows=1,103,709 loops=3)

  • Hash Cond: ((pt.title_id)::text = (r.title_id)::text)
8. 1,197.603 1,197.603 ↑ 1.2 5,004,000 3

Parallel Seq Scan on people_titles pt (cost=0.00..158,167.76 rows=6,254,976 width=20) (actual time=0.006..399.201 rows=5,004,000 loops=3)

9. 15.717 135.774 ↑ 1.3 23,598 3

Parallel Hash (cost=11,722.33..11,722.33 rows=29,609 width=10) (actual time=45.258..45.258 rows=23,598 loops=3)

  • Buckets: 131072 Batches: 1 Memory Usage: 4416kB
10. 120.057 120.057 ↑ 1.3 23,598 3

Parallel Seq Scan on ratings r (cost=0.00..11,722.33 rows=29,609 width=10) (actual time=0.010..40.019 rows=23,598 loops=3)

  • Filter: ((rating > '5'::numeric) AND (votes > 500))
  • Rows Removed by Filter: 286020
11. 107.874 595.218 ↑ 1.2 172,140 3

Parallel Hash (cost=98,749.17..98,749.17 rows=213,742 width=10) (actual time=198.406..198.406 rows=172,140 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 28352kB
12. 487.344 487.344 ↑ 1.2 172,140 3

Parallel Seq Scan on titles t (cost=0.00..98,749.17 rows=213,742 width=10) (actual time=0.011..162.448 rows=172,140 loops=3)

  • Filter: (kind_id = 2)
  • Rows Removed by Filter: 1769749
13. 17,750.048 17,750.048 ↑ 1.0 1 2,218,756

Index Scan using people_pkey on people p (cost=0.43..0.48 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=2,218,756)

  • Index Cond: ((name_id)::text = (pt.name_id)::text)
  • Filter: (death_year IS NULL)
  • Rows Removed by Filter: 0
Planning time : 0.769 ms
Execution time : 13,167.901 ms