explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZfFc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11,223.29..4,225,204.54 rows=5,556,089 width=59) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=11,222.59..11,237.45 rows=1,486 width=19) (actual rows= loops=)

  • Group Key: (pc1.object_referenz)::text
3. 0.000 0.000 ↓ 0.0

Index Scan using i_pc_listing_type on publishing_count pc1 (cost=0.44..11,218.87 rows=1,488 width=19) (actual rows= loops=)

  • Index Cond: ((publishing_timestamp >= (date_trunc('month'::text, (('now'::cstring)::date)::timestamp with time zone) - '1 mon'::interval
4. 0.000 0.000 ↓ 0.0

Index Scan using i_pc_obj_adv on publishing_count (cost=0.70..2,828.00 rows=778 width=31) (actual rows= loops=)

  • Index Cond: ((object_referenz)::text = (pc1.object_referenz)::text)