explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yRtH

Settings
# exclusive inclusive rows x rows loops node
1. 198.589 639.153 ↓ 1.1 1,120,942 1

Unique (cost=1.12..107,041.26 rows=999,939 width=8) (actual time=0.041..639.153 rows=1,120,942 loops=1)

2. 92.707 440.564 ↑ 1.0 1,120,942 1

Merge Append (cost=1.12..104,138.11 rows=1,161,261 width=8) (actual time=0.040..440.564 rows=1,120,942 loops=1)

  • Sort Key: bool.c_documentid
3. 0.017 0.017 ↓ 0.0 0 1

Index Scan using "UQ_83a9a5dc-5667-4aeb-92f4-efa3d9184431" on t_e20so1_document_boolean bool (cost=0.56..1,404.55 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (c_fieldid = 'ee88767a-c251-4317-8d3e-fd01296a35db'::uuid)
  • Filter: (c_value AND (c_tablegroupsid = 'e4308ac6-c388-11e7-8c54-9b97e6527505'::uuid))
4. 347.840 347.840 ↑ 1.0 1,120,942 1

Index Scan using uc_unique_t_e20so1_document_boolean_folders on t_e20so1_document_boolean_folders bool_1 (cost=0.56..91,120.94 rows=1,161,260 width=8) (actual time=0.022..347.840 rows=1,120,942 loops=1)

  • Index Cond: (c_fieldid = 'ee88767a-c251-4317-8d3e-fd01296a35db'::uuid)
  • Filter: (c_value AND (c_tablegroupsid = 'e4308ac6-c388-11e7-8c54-9b97e6527505'::uuid))
Planning time : 0.332 ms