explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SP1e

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.048 ↑ 100.0 1 1

Function Scan on jsonb_each (cost=8.45..11.95 rows=100 width=320) (actual time=0.048..0.048 rows=1 loops=1)

2.          

Initplan (forFunction Scan)

3. 0.022 0.022 ↑ 1.0 1 1

Index Scan using consumer_pkey on consumer (cost=0.43..8.45 rows=1 width=32) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: (application_data_id = 4829603)