explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 45Ph

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 13,945.411 ↑ 1.0 50 1

Limit (cost=90,895.46..90,896.46 rows=50 width=398) (actual time=13,945.350..13,945.411 rows=50 loops=1)

2. 0.039 13,945.405 ↑ 2.0 50 1

Unique (cost=90,895.46..90,897.42 rows=98 width=398) (actual time=13,945.349..13,945.405 rows=50 loops=1)

3. 8.882 13,945.366 ↑ 2.0 50 1

Sort (cost=90,895.46..90,895.70 rows=98 width=398) (actual time=13,945.347..13,945.366 rows=50 loops=1)

  • Sort Key: n.published_at DESC, n.id, n.title, n.description, n.impact, sn.acronym, sn.name
  • Sort Method: quicksort Memory: 1,868kB
4. 88.890 13,936.484 ↓ 31.5 3,084 1

Nested Loop Left Join (cost=23,217.36..90,892.22 rows=98 width=398) (actual time=7,148.598..13,936.484 rows=3,084 loops=1)

  • Join Filter: (n.publisher_id = sn.id)
  • Rows Removed by Join Filter: 515,028
5. 6,660.486 13,795.166 ↓ 31.5 3,084 1

Hash Join (cost=23,217.36..90,641.16 rows=98 width=380) (actual time=7,148.544..13,795.166 rows=3,084 loops=1)

  • Hash Cond: (rs.news_id = n.id)
6. 74.771 87.887 ↑ 1.0 62,345 1

Bitmap Heap Scan on screening_newsrelatedstock rs (cost=1,445.67..65,054.80 rows=63,127 width=4) (actual time=18.811..87.887 rows=62,345 loops=1)

  • Recheck Cond: (stock_id = 21,830)
  • Heap Blocks: exact=31,931
7. 13.116 13.116 ↑ 1.0 62,652 1

Bitmap Index Scan on screening_newsrelatedstock_stock_id_87f2bc2a (cost=0.00..1,429.89 rows=63,127 width=0) (actual time=13.116..13.116 rows=62,652 loops=1)

  • Index Cond: (stock_id = 21,830)
8. 4,562.637 7,046.793 ↓ 22.8 1,408,991 1

Hash (cost=17,914.92..17,914.92 rows=61,901 width=380) (actual time=7,046.792..7,046.793 rows=1,408,991 loops=1)

  • Buckets: 16,384 (originally 16384) Batches: 256 (originally 8) Memory Usage: 3,969kB
9. 2,484.156 2,484.156 ↓ 22.8 1,408,991 1

Index Scan using screening_acmnews_published_at_f6b6e991 on screening_acmnews n (cost=0.57..17,914.92 rows=61,901 width=380) (actual time=0.044..2,484.156 rows=1,408,991 loops=1)

  • Index Cond: ((published_at >= '2020-06-19 00:00:00+00'::timestamp with time zone) AND (published_at < (now() + '00:02:00'::interval)))
  • Filter: (id > 1400000)
10. 52.380 52.428 ↑ 1.0 168 3,084

Materialize (cost=0.00..4.52 rows=168 width=26) (actual time=0.000..0.017 rows=168 loops=3,084)

11. 0.048 0.048 ↑ 1.0 168 1

Seq Scan on screening_newspublisher sn (cost=0.00..3.68 rows=168 width=26) (actual time=0.008..0.048 rows=168 loops=1)

Planning time : 2.261 ms
Execution time : 13,946.473 ms