explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jiRs

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.123 ↑ 1.0 1 1

Aggregate (cost=9.26..9.27 rows=1 width=12) (actual time=0.123..0.123 rows=1 loops=1)

  • Buffers: shared hit=7 read=1
2. 0.001 0.121 ↓ 0.0 0 1

GroupAggregate (cost=9.17..9.21 rows=2 width=46) (actual time=0.121..0.121 rows=0 loops=1)

  • Group Key: lnk_entity_flg.p_entity_uuid, lnk_entity_flg.dwh_begin_date, lnk_entity_flg.dwh_end_date
  • Filter: (sum(lnk_entity_flg.flg_act) > 0)
  • Buffers: shared hit=7 read=1
3. 0.052 0.120 ↓ 0.0 0 1

Sort (cost=9.17..9.17 rows=2 width=50) (actual time=0.120..0.120 rows=0 loops=1)

  • Sort Key: lnk_entity_flg.p_entity_uuid, lnk_entity_flg.dwh_begin_date, lnk_entity_flg.dwh_end_date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7 read=1
4. 0.001 0.068 ↓ 0.0 0 1

Append (cost=0.00..9.16 rows=2 width=50) (actual time=0.068..0.068 rows=0 loops=1)

  • Buffers: shared hit=1 read=1
5. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on lnk_entity_flg (cost=0.00..1.00 rows=1 width=22) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (((c_entity_uuid)::text = '1'::text) AND (lnk_lvl = 1) AND (dwh_partition_id = '0'::bigint))
  • Buffers: shared hit=1
6. 0.059 0.059 ↓ 0.0 0 1

Index Scan using lnk_entity_flg_0_lnk_lvl on lnk_entity_flg_0 (cost=0.14..8.16 rows=1 width=78) (actual time=0.059..0.059 rows=0 loops=1)

  • Index Cond: ((lnk_lvl = 1) AND ((c_entity_uuid)::text = '1'::text))
  • Filter: (dwh_partition_id = '0'::bigint)
  • Buffers: shared read=1
Planning time : 0.441 ms
Execution time : 0.187 ms