explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RNoD

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 14.923 ↑ 6.0 1 1

Nested Loop (cost=426.86..76,581.67 rows=6 width=5,179) (actual time=14.891..14.923 rows=1 loops=1)

2. 0.082 0.082 ↑ 16.0 1 1

Index Scan using fk_tblapplication_vacancyid_autoidx on tblapplication (cost=0.42..17.87 rows=16 width=4,752) (actual time=0.076..0.082 rows=1 loops=1)

  • Index Cond: (vacancyid = 759,071)
3. 0.147 14.828 ↑ 1.0 1 1

Bitmap Heap Scan on auditlog (cost=426.44..4,785.23 rows=1 width=427) (actual time=14.803..14.828 rows=1 loops=1)

  • Recheck Cond: (refid @> ((('{"tblapplication.applicationid": "'::text || (tblapplication.applicationid)::text) || '"}'::text))::jsonb)
  • Filter: (component = 'NursingNet_Block_PrintingPack'::text)
  • Rows Removed by Filter: 6
  • Heap Blocks: exact=3
4. 14.681 14.681 ↑ 725.3 7 1

Bitmap Index Scan on auditlog_reference_idx (cost=0.00..426.44 rows=5,077 width=0) (actual time=14.681..14.681 rows=7 loops=1)

  • Index Cond: (refid @> ((('{"tblapplication.applicationid": "'::text || (tblapplication.applicationid)::text) || '"}'::text))::jsonb)
Planning time : 26.532 ms
Execution time : 15.482 ms